Type something and hit enter

ads here
Home invest in investing living frugal what to invest in Webscraping Index PEs With Excel VBA

Webscraping Index PEs With Excel VBA

On
advertise here

Demo using Selenium, the Excel VBA Browser Automation software, to webscrape price and earnings per share data from Yahoo Finance.

https://youtu.be/R__f0ifMWn0

I found this helpful for calculating Price to Earnings ratios for index funds that do not list their fund PE values. Getting the PE ratio can help identify when the stocks of some indexes may be overvalued.

Of course, VBA can also automate any similar routine data entry and extraction, this is just a nice example project.



Submitted March 27, 2022 at 12:12AM by ImOnYourScreen https://ift.tt/oP2IGhT
invest ininvestingliving frugalwhat to invest in
advertise here

Click to comment
Subscribe to: Post Comments (Atom)