02 Get Input data

In [9]:

    

import time
import datetime
from yahoo_finance import Currency


    

In [10]:

    

import medareda_lib

def get_conn():
    return medareda_lib.get_conn()


    

In [11]:

    

import time
def get_price(ticker):
    #print '-----------'
    #Currency('GBPUSD').refresh()
    bid = Currency(ticker).get_bid()
    rate = Currency(ticker).get_rate()
    ask = Currency(ticker).get_ask()
    
    trade_datetime  = Currency(ticker).get_trade_datetime ()

    print ticker, bid

    conn = get_conn()
    c  = conn.cursor()
    now = datetime.datetime.now()
        
    sql = "INSERT INTO iPrice (iDate,status,date,symbol,bid,rate,ask) VALUES ('%s','%s','%s','%s',%s,%s,%s) " %( now ,'wait',trade_datetime,ticker,bid,rate,ask)
    #print sql
    c.execute(sql)
    conn.commit()
    conn.close()
    return bid


    

In [4]:

    

# get some input data

gbp_usd = get_price('GBPUSD')
eur_gbp = get_price('EURGBP')
usd_eur = get_price('USDEUR')

if gbp_usd:
    print gbp_usd, eur_gbp, usd_eur , float(gbp_usd) * float(eur_gbp) * float(usd_eur)
else:
    print gbp_usd


    

    




GBPUSD 1.5484
EURGBP 0.7415
USDEUR 0.8709
1.5484 0.7415 0.8709 0.99991390674

In [15]:

    

#while True:
for i in range(2):    
    for ticker in ('GBPUSD','EURGBP','USDEUR'):
        get_price(ticker)


    

    




GBPUSD 1.5473
EURGBP 0.7354
USDEUR 0.8787
GBPUSD 1.5473
EURGBP 0.7355
USDEUR 0.8787

In [ ]:

    




    

In [ ]:

    




    

In [ ]:

    




    

In [ ]:

    




    

In [ ]: