View Full Version : Excel programming help
Hi all,
Does anyone know how to incorporate a end-of-day data feed for ASX200 stocks into MS Excel?
Snow Leopard
07-02-2009, 05:13 PM
That is a pretty vague specification. :(
A really simple way to get end of day data in Excel is to download it direct from AFR (http://www.afr.com/home/tables.aspx) :rolleyes:
regards
Paper Tiger
Next step is to get excel to flick off a warning by changing a cell value or painting a cell red if the price for a particular symbol breaks a new high in that spreadsheet from AFR. That should be a series of IF statements I'm figuring...
Thanks a heap for the help, it's not as automated as I first wanted but it's a "90% less effort for 10% less functionality" solution which is great :)
Another solution. Wasn't sure if it would work on XP, but some further research reveals that Office XP and Office 2002 are one and the same :)
http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1&displaylang=en
winner69
07-02-2009, 07:03 PM
That is a pretty vague specification. :(
A really simple way to get end of day data in Excel is to download it direct from AFR (http://www.afr.com/home/tables.aspx) :rolleyes:
regards
Paper Tiger
Interesting file that showed the rolling year highs and lows
3 stocks at a 52 week highs and 2 were warrants
and 60 odd at a 52 week low
State of the market suppose
An entire blog dedicated to Excel backtesting and simulated trading with excel.
http://exceltrader.blogspot.com/2008/04/simulatorxls-version-1.html
marknz88
08-02-2009, 09:47 PM
Thanks for sharing that link AMR!
very interesting blog indeed :)
Mysterybox
10-02-2009, 02:33 PM
thanks AMR
.
There are some informative Excel books here (for free)
Excel (http://www.scribd.com/search?c=all&query=excel&commit=Search)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.