Free data that downloads into Excel
- Thread starter nizar
- Start date
What data are you wanting to download? And how would you expect the data to be downloaded? That is, what is wrong with the data that you can download from Yahoo groups. I have the link if you want it... that is, you can download the contents of the file to you desktop and then open into excel. Or you can try float.com.au
Tim
Tim
EOD data for ASX stocks is what Im after.
Float.com.au looks the goods.
CSV format download should have no worris getting into Excel.
THanks Tim.
- Joined
- 5 July 2005
- Posts
- 14
- Reactions
- 0
If I can be so bold to let you know about some differences that I have found and may change how you approach this but... what I have noticed with float.com.au is that if a stock has not traded for a day, and the O, H, L, C are all 0, this is what you get in a file from float.com.au. Now the same data from commsec, or cooltrader (even yahoo) would have the prev. close greater than 0. Commsec by way of comparison, does not include indices, whereas the others do.
Just make sure the data you get has the information you are looking for.
Tim
Just make sure the data you get has the information you are looking for.
Tim
Just something else to throw into the mix... the Yahoo data only contains rows for stocks that have traded. To illustrate the differences....
if a stock traded at 60c (say 2 days ago) and trading was halted, the files from each service (for this stock would look similar to)...
float.com.au...
XXX,0.0,0.0,0.0,0.0,0
comsec or cooltrader (free or subscription)...
XXX,0.60,0.60,0.60,0.60,0
yahoo...
there will be no record for this stock in the file.
Therefore it depends on what data you expect to find in the file and what application(s) use the data and use the data in an consistent manner so that results are not mangled due to some decision to change to some other provider.
Tim
PS. I am not for or against free (vs paying) providers, but if people look for or want to use free data they should know what they are getting. The line that on "only data you pay for is good" does not entirely apply if you know exactly what you are doing and/or what you are getting (for free).
if a stock traded at 60c (say 2 days ago) and trading was halted, the files from each service (for this stock would look similar to)...
float.com.au...
XXX,0.0,0.0,0.0,0.0,0
comsec or cooltrader (free or subscription)...
XXX,0.60,0.60,0.60,0.60,0
yahoo...
there will be no record for this stock in the file.
Therefore it depends on what data you expect to find in the file and what application(s) use the data and use the data in an consistent manner so that results are not mangled due to some decision to change to some other provider.
Tim
PS. I am not for or against free (vs paying) providers, but if people look for or want to use free data they should know what they are getting. The line that on "only data you pay for is good" does not entirely apply if you know exactly what you are doing and/or what you are getting (for free).
