[DUPLICATE] "Market Capitalization (ttm)" and index out of range
Author: deepbuyer
Creation Date: 8/9/2008 4:49 PM
profile picture

deepbuyer

#1
I am trying to incorporate the market cap value in the code. I used the strategy builder to find how to get the market cap. Strategy builder if great, by the way, I had no idea I could just dig in there and get the market cap. Anyways,the code below gives "index out of range" for BA, HON and some other stocks. It does work for ~2/3 of the Dow30. I see that there is a file in fundamental folder for BA of roughly the same size as for the stocks that do work. I don't know how to look inside and if the problem is even in the data file.
CODE:
Please log in to see this code.
profile picture

Eugene

#2
See this thread for the known problem description and workaround.
profile picture

deepbuyer

#3
market cap for ETFs is 0.00 for some reason. do i understand it correctly that the fundamental data from fidelity does not cover ETFs?
profile picture

Eugene

#4
Since it looks like a data issue, better if it's reported to Fidelity.
profile picture

Cone

#5
Are you even sure that ETFs report "Financials"? Can you find these data on one of the ETF sites?

In my opinion, just imagine the garbage you'd have to sift through by combining financial statements of ETF constituent companies that could include 1-time write-offs and distributions. It's hard enough to make sense out of it for just 1 company!
profile picture

Eugene

#6
QUOTE:
Are you even sure that ETFs report "Financials"? Can you find these data on one of the ETF sites?

It doesn't make much sense to me too, but for instance, Google and Yahoo finance sites are reporting "market cap" and "net assets" respectively.