Thursday, September 3, 2015

looking for sources to get 10 or 15 yr financial history of companies

I was wondering what sources you use to get 10 or 15 yr financial histories of companies. Particularly important to me if it includes the ASX listed (Australian).

I'm looking for something like this example (but on guru you have to go hefty premium to get the information in its entirety).

Also, a second bonus question just in case: My longer objective is to use this to set up a google spreadsheet with a ticker to auto-import the tables. I've tried this with morningstar.com.au, but I'm reasonably new and don't know what I'm doing wrong. It works on guru but not on morningstar. If anyone can point out what's wrong that'd also be of great help.

For guru I type;

=importhtml("http://ift.tt/1ASDSrQ<insert stock code>","table",3)

That works and it imports financial history!

For morningstar I type:

=importhtml("http://ift.tt/1KuovPO<insert stock code>","table",1)

and it doesn't work. Source says there are 8 tables on the page and none of 1-8 work.

The only thing I can think of is that on morningstar I have to login to my account to actually see the financial history and when google spreadsheets looks it up it is met with that wall. Any advice would be appreciated. If you already have or know of a google spreadsheet that does this that would be greatly appreciated too!



Submitted September 03, 2015 at 03:05PM by CitizenSnipsReturned http://ift.tt/1QbK0DV

No comments:

Post a Comment