hist_stock_data - only 2 decimals with currency

7 views (last 30 days)
Hello!
I have a very simple code for downloading the historical prices from yahoo finance. If I use:
%--------
start_date = '01032012';
end_date = '11072012';
stocks = hist_stock_data(start_date, end_date, '^GSPC');
stocks.Date=datenum(stocks.Date);
% reverse vectors old -> new
stocks.Date = stocks.Date(end:-1:1);
stocks.Close = stocks.Close(end:-1:1);
Prices=stocks.Close
%---------
then the vector prices has 4 decimals. However, if I instead of '^GSPC' use 'EURUSD=X', then the 3rd and 4th decimals are always 0, i.e. the numbers are rounden. HOwever, on the website http://finance.yahoo.com/q?s=EURUSD%3DX&ql=0
the quotes have 4 decimals. Is there a way to download currency data with 4 decimals instead of 2?
Thank you very much for your time and consideration!
Alex

Accepted Answer

Javier
Javier on 13 Sep 2012
Edited: Walter Roberson on 2 Jul 2018
Hello Alex
Procedure to Get Price (EURUSD) with 4 decimals here.If yahoo doesnt allow you go the data , you can go to fred page to get the data (Federal Reserve Economic Data - FRED - St. Louis Fed data manager). Please read the communicate with Data Serve help information in Matlab.
Solution done in Matlab R2012a.
conn=fred;
Instrument='DEXUSEU';
DateIni='Jan 01 2002';
DateEnd='Jan 01 2012';
Field='Close';
Price=fetch(conn,Instrument,Field,DateIni,DateEnd);
How did I identify the name of the instrument ? Go to the FRED Graph section and search the instrument. For the EURO I put EURO and get the result:
DEXEUS, D, USD, $ to 1, USA, NSA.
This means that data are daily, dollar price NSA.
If this solve your question please grade. Best regards
Javier

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!