I want to build a worksheet where the user can input a Stock symbol and the balance sheet is automatically downloaded from morningstar to a table, and then some custom formulas are run on the data.
On github I found the hidden morningstar API: https://gist.github.com/hahnicity/45323026693cdde6a116
E.g. to retrieve some financials, I use (in my browser): http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=TWTR&reportType=is&period=12&dataType=A&order=asc&columnYear=5&number=3
Now I tried to start by building a query using Data->New Query->From different source->From web, I entered the URL and instead of seeing the actual csv-data as in my browser, a popup appears to actually open the file in a new Excel window. Even when trying to query a csv and entering the URL there, it doesnt work.
I do NOT want to open this file, I want to query the csv data!
Any ideas why it doesnt work? And how to make it actually work?
Thanks a lot