Web Scrapping on Google sheet App Srcipt -- 2
Budget: $30 – $250 USD
I want to make it so I simply type in stock Ticker (e.g. Symbol: AAPL) in the first cell within a row and the row is automatically updated with real-time stock market numbers. I need help web scraping the data from yahoo finance (or from somewhere public).
https://docs.google.com/spreadsheets/d/1_dB2IvGCXVSGkIGNsMXwNSNhDKH8jB4T0v0KdMC4P2A/edit?usp=sharing
as i have 29 companies i already typed in manually , i really desire just one clean row that could accept new company symbol (eg: AAPL , GOOG , FB) and then have remainder of columns populate with real time data.
and to repeat this for up to infinity rows (each for a new company)
also, please don’t overwrite the example file i sent you. please create new Google sheets file.
https://docs.google.com/spreadsheets/d/1_dB2IvGCXVSGkIGNsMXwNSNhDKH8jB4T0v0KdMC4P2A/edit?usp=sharing
as i have 29 companies i already typed in manually , i really desire just one clean row that could accept new company symbol (eg: AAPL , GOOG , FB) and then have remainder of columns populate with real time data.
and to repeat this for up to infinity rows (each for a new company)
also, please don’t overwrite the example file i sent you. please create new Google sheets file.