Yahoo! Finance Database Issue with Fetch

1 次查看（过去 30 天）
Andrew Burns
Andrew Burns 2017-3-18
评论： Andrew Burns 2017-3-19
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

请先登录，再回答此问题。

采纳的回答

Florian
Florian 2017-3-19
Hi Andrew, the timeseries you get are not normalized. What I do is store the individual series in a structure and after downloading I -
  • Item one Item twoGenerate a list of all dates across all tickers
  • Item two Fill in all timeseries at their appropriate dates with ismember
This way you end up with an alligned price matrix across all tickers.
Hope this helps, Florian
  1 个评论
Andrew Burns
Andrew Burns 2017-3-19
Would you be able to share that part of your script so I can understand what you are saying better?
So as per my example, in your list you'd never be calling for data on FaceBook (ticker: FB) in a time period that there is no Yahoo! data for it?

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Financial Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by