Hi,
Can someone help me in extracting one particular value from a website through macro for list of stocks. The link is http://www.advfn.com/exchanges/NYSE/BAC/financials
I want to extract WACC, tobins, cash ratio, cash flow liquidity, times interest earned, book value per share and working capital for list of stocks through a macro and i want the file to be dynamic.
Let me know if any one can help. Also i have attached excel file.
Regards,
Cyrus
Bookmarks