Excel programming help

[AMR]

Hi all,

Does anyone know how to incorporate a end-of-day data feed for ASX200 stocks into MS Excel?

[Snow Leopard]

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

[AMR]

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 :)

[AMR]

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]

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

[AMR]

An entire blog dedicated to Excel backtesting and simulated trading with excel.

http://exceltrader.blogspot.com/2008/04/simulatorxls-version-1.html

[marknz88]

Thanks for sharing that link AMR!

very interesting blog indeed :)

[Mysterybox]

thanks AMR

[arco]

.

There are some informative Excel books here (for free)

Excel (http://www.scribd.com/search?c=all&query=excel&commit=Search)