fbpx

Stock Picks for the week by First Metro Securities

Check out the Stock Picks for the week by First Metro Securities in this special report which you can find only here in PinoyInvestor. (Needs premium access.)


READ REPORT
22

Here’s A Quick Way To Export Morningstar Financial Data In Just 1 Click

A few weeks ago, I made a post about the sites I use to get financial data. One site I mentioned is Morningstar.

If you tried searching for a particular company listed in the PSE on the site itself, you’ll find out that it’s really a pain in the ass. If you don’t have any idea of what I’m talking right now, try searching in the site and see for yourself.

​But here’s what I like about Morningstar…

​I like the fact that you can export Income Statements, Balance Sheets, and Cash Flow Statements for a stock listed in PSE into a .csv file.

​What I don’t like is the time it takes to accomplish this task.

To export the financial data, you have to do the following in order;​

  • Google the ticker and click on the link that’s connected to Morningstar.
  • Go to the Financials Tab, click Income Statement and click “EXPORT”.
  • Search and open the file you just downloaded.
  • Copy and paste the data in your excel worksheet.
  • Do steps 1 to 4 for the rest of the data (Balance Sheet, Cash Flow Statement, Key Ratios, Historical Prices).

This becomes a lot of work when you are trying to export all financial data from multiple companies. Imagine that you have to do these five steps for ten companies you wish to screen.

​Tough work isn’t it?

​Now what if there’s a quick way to export these financial data in just one click? It would really make valuation easier wouldn’t it?

If you’re looking for an easy way to download financial data, then don’t worry. I’ve created a solution for this.​

Introducing The Investment Research Tool

I made a spreadsheet tool where you can just enter the ticker symbol and the export links would be available in an instant.​

Here’s the screenshot of the tool (see Fig. 1).​

Fig. 1

This tool lets you enter a ticker and the export links will be automatically available in an instant.

Let’s say you want to get Ayala Land Inc.’s (ALI) financial data, you just need to enter ALI in the ticker box and you’ll see that the files you need are all ready for export (see Fig. 2 below).

Fig. 2

With this tool, you no longer have to search Google and browse the Morningstar website.

You don’t even have to search for the files in your hard drive because it also opens automatically once the export is finished. You no longer have to go to the downloads folder or anywhere to find the file you saved. You can immediately copy and paste the data in your worksheet.

Pretty neat isn’t it?

(Note: This tool is no longer available because the scrapping method no longer works after Morningstar updated their website. Sorry!)

The Financial Statements are worth five years of data plus the TTM estimates. The historical prices are set to max where you have five options to choose from.

Final Thoughts

Use this tool to hasten your research and valuations.

Just a disclaimer though, this tool is not supported by Morningstar Inc. The API calls I used in the spreadsheet may change without notice. If the tool is no longer working, let me know so that I can try to fix the cell parameters I used in the spreadsheet.

This tool is absolutely free and if you find it useful, kindly share it to people you know that would benefit from it.

Happy investing!

  • November 6, 2016

Model Portfolios: Unloved, Value Play, Yield Seeker, Riding the Momentum

Looking for model portfolios to guide your stock picking decisions? Don't worry, we got you covered! Check out this special stock picks and model portfolio report today! (Needs premium access.)


READ REPORT
  • Jed says:

    Awesome post! Very helpful and convenient for everybody to use! Thank you very much engineer! ??

  • JRP says:

    Echoing Jed’s post. Much appreciated sir!

  • Dan says:

    Pano po yung may lumalabas na unprotect sheet? slamat po.

  • Heston says:

    Thanks for this, Bro!!!

  • abelardo says:

    very helpful for other investors..keep up the good work sir.

  • Nick says:

    Amazing job! Thanks a lot for your efforts!
    However, when I click Export CSV, only a white empty page come up. Should I change something in my settings? Thanks again!

  • A says:

    Hi,

    An interesting website. However your buttons to download the spreadsheet do not seem to work. All I got in my email was a confirmation of subscription to your website.

    Can you please confirm if the tool is available for download?
    Thanks

  • Is there also a way to download CSV/ annual pdf files of chinese companies? Thanks! 🙂

  • Emil says:

    Hi, do you sign up for Morning Star premium subscription to get the 10 year historical data, like some of your stock analysis?

  • Pearl says:

    Thank you so much for this!

  • Ron says:

    Kumusta,
    Do you have a workaround for the THE INVESTMENT RESEARCH TOOL, to import Morningstar data, or could you send me a copy of the worksheet/tool to see how you got the data originally, then try and amend it. Or could you please advise how you get the data now.
    Salamat.

  • Ron says:

    Hi,
    Sorry I took so long to get back to you, I lost the link :>(. Anyway here are three table links I found for Morningstar.com.au, Hopefully, this what you want. I cannot do this for AU stocks as the table data is dynamic java data. Damn.
    (1) =ARRAYFORMULA((IMPORTHTML(“http://financials.morningstar.com/valuate/valuation-history.action?&t=”& $B$9 &”&region=usa&culture=en-US&cur=&type=price-sales&”,”table”, 1)))
    (2) =ARRAYFORMULA(regexreplace(IMPORTHTML(“http://financials.morningstar.com/finan/financials/getKeyStatPart.html?t=”& $B$9 &”&region=usa&culture=en-US&ops=clear”,”table”, 2),”]*>|—”,””))
    (3) =ARRAYFORMULA(regexreplace(IMPORTHTML(“http://financials.morningstar.com/finan/financials/getKeyStatPart.html?t=”& $B$9 &”&region=usa&culture=en-US&ops=clear”,”table”, 6),”]*>|—”,””))
    Note: Put your ticker code in cell B9, or change it to whatever cell you want.
    maayo nga udto

  • >