I need someone to write a script that will pull data from morningstar.com and put it into an excel model.
I uploaded the model I would like people to work with. I need
I want to type the ticker in cell F6 and the following information pop up.
1. Quarterly Income statement,balance sheet, statement of cash flows for the most recent 8 quarters. FY14 and FY15
2. Yearly Income statement, balance sheet, statement of cash flows for years FY10-FY15
3. Formatting. I would like revenue, operating income, net incomes, Total Assets, Total Liabilities, Total Stockholders Equity, Operating Cash flows, Investing cash flows, and financing cash flows to be bolded. I want the numbers in accounting format with 0 decimal places