python - How can get ' USDJPY'(currency rates) with pandas and yahoo finance? -


i learning , using pandas , python.

today, trying make fx rate table, got trouble getting pricess of 'usdjpy'.

when prices of 'eur/usd', code this.

eur = web.datareader('eurusd=x','yahoo')['adj close']

it works.

but when wrote 

jpy = web.datareader('usdjpy=x','yahoo')['adj close']

the error message comes this:

--------------------------------------------------------------------------- ioerror traceback (most recent call last) in () ----> 1 jpy = web.datareader('usdjpy=x','yahoo')['adj close']

c:\anaconda\lib\site-packages\pandas\io\data.pyc in datareader(name, data_source, start, end, retry_count, pause) 70 return get_data_yahoo(symbols=name, start=start, end=end, 71 adjust_price=false, chunksize=25, ---> 72 retry_count=retry_count, pause=pause) 73 elif data_source == "google": 74 return get_data_google(symbols=name, start=start, end=end,

c:\anaconda\lib\site-packages\pandas\io\data.pyc in get_data_yahoo(symbols, start, end, retry_count, pause, adjust_price, ret_index, chunksize, name) 388 """ 389 return _get_data_from(symbols, start, end, retry_count, pause, --> 390 adjust_price, ret_index, chunksize, 'yahoo', name) 391 392

c:\anaconda\lib\site-packages\pandas\io\data.pyc in _get_data_from(symbols, start, end, retry_count, pause, adjust_price, ret_index, chunksize, source, name) 334 # if single symbol, (e.g., 'goog') 335 if isinstance(symbols, (basestring, int)): --> 336 hist_data = src_fn(symbols, start, end, retry_count, pause) 337 # or multiple symbols, (e.g., ['goog', 'aapl', 'msft']) 338 elif isinstance(symbols, dataframe):

c:\anaconda\lib\site-packages\pandas\io\data.pyc in _get_hist_yahoo(sym, start, end, retry_count, pause) 188 '&g=d' + 189 '&ignore=.csv') --> 190 return _retry_read_url(url, retry_count, pause, 'yahoo!') 191 192

c:\anaconda\lib\site-packages\pandas\io\data.pyc in _retry_read_url(url, retry_count, pause, name) 167 168 raise ioerror("after %d tries, %s did not " --> 169 "return 200 url %r" % (retry_count, name, url)) 170 171

ioerror: after 3 tries, yahoo! did not return 200 url 'http://ichart.yahoo.com/table.csv?s=usdjpy=x&a=0&b=1&c=2010&d=1&e=1&f=2014&g=d&ignore=.csv'

other currencies 'gbpusd' have same problem.

can solve problem?

do have idea of getting 'usdjpy' yahoo or google???

yahoo finance doesn't provide historical data on exchange rates (i.e. there's no "historical prices" link in top left of page there stocks, indices, etc...)

you can use fred (federal reserve of st. louis data) these exchange rates...

import pandas.io.data web  jpy = web.datareader('dexjpus', 'fred')

or more direct way...

jpy = web.get_data_fred('dexjpus')

a list of of exchange rate fred has daily data can found here: http://research.stlouisfed.org/fred2/categories/94


-

Comments

Post a Comment

Popular posts from this blog

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more

sql - Select Query has unexpected multiple records (MS Access) -

i may tired, can't seem figure out happening. have 2 queries. query 1 has 10 fields. query 2 has 5 fields. fields 1 through 3 same in both queries. trying write select query , simple add field 5 query2 query1 result should query1 additional field (query2.field5). i join first 3 fields both queries , choose select records in query1 , in query2 match. don't know sql, use query designer. expect same number of records have query 1 instead have 3 times or more. can tell me doing wrong. tried reversing joins still seem same records. thanks in advance. here query: the fields in common divisionname , supplierid = vendorid , commodityname . select [part revenue exposed query p1].divisionname, [part revenue exposed query p1].commodityname, [part revenue exposed query p1].suppliername, [part revenue exposed query p1].partnumber, [part revenue exposed query p1].partdescription, [part revenue exposed query p1].bucode, ...
Read more