I thought I'd continue developing a nice excel spreadsheet, eventually allowing it to display a full portfolio of different assets, along with charts, ratio's etc amongst plenty more.
Can you link up a 'feed' (don't know if that's the correct term) type service to an excel spreadsheet. I'd ideally love it if say there was a box, you could type ANZ.AX in it and it would bring up the statements for ANZ, which excel would then of course fill out the corresponding ratios automatically as programmed by myself. Once you're done, you just simply type WOW.AX and you get the Woolworths data. Sort of like it automatically searches for the information on the internet/yahoo/google/bloomberg (whatever it has to be linked to)
Only other way I thought you could do it that way is perhaps have a database of the information on the computer which it locates the corresponding stock ticker from it. Can it do this?
If anyone else has any other information on how to automate a spreadsheet as much as possible, that'd be awesome (besides the obvious stuff).