- Item one Item twoGenerate a list of all dates across all tickers
- Item two Fill in all timeseries at their appropriate dates with ismember
Yahoo! Finance Database Issue with Fetch
2 views (last 30 days)
Show older comments
Do any of you know of a way to remedy this issue?
When you fetch Yahoo data, and you pass a list of tickers and date ranges, there are times where some tickers in the list didn't trade within the particular date range. So what happens in the query ceases entirely. Ideally I'd want the returned data to just show NaNs for the dates that a particular issue didn't trade, next to the populated fields of other tickers that did trade and therefore have data.
As an example ... say I wanted adjusted close prices for 'IBM' and 'FB' (FaceBook) from May 2010 to today. IBM of course has been trading way before 2010, but FB didn't IPO until May '12 so from 2010 to May '12 there wouldn't be any data. So ideally I want to show NaNs for FB from 2010 to May '12 then the adjusted closing prices from May '12 to today.
Thanks in advance for any input.
Andrew
0 Comments
Accepted Answer
Florian
on 19 Mar 2017
Hi Andrew, the timeseries you get are not normalized. What I do is store the individual series in a structure and after downloading I -
This way you end up with an alligned price matrix across all tickers.
Hope this helps, Florian
More Answers (0)
See Also
Categories
Find more on Financial Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!