Pull Financial Statements from a website

[Jeffreyxx01]

Hi guys,

I am in need of a macro and I dont actually know how to write it,
I want to pull data from this website:

http://tools.morningstar.co.uk/uk/s...ALL&Id=0P00006TF8&ClientFund=0&CurrencyId=USD

Like I wanna be able to pull data using the ticker name as for example:

Ticker : FSLR for Income statement, Balance Sheet and Cash Flows.

If anyone has a clue how to write it,

Please help me.

 

[ranman256]

You can copy/paste. Select the data starting with INCOME STATEMENT to the last value, -3.48
paste into a new worksheet,
then run a macro to do what you need to it.

build the macro by turning on the recorder then edit it.

 

[Jeffreyxx01]

I dont actually see the way to make that,
Recording a macro while using a webpage will not record my changes from the webpage.