Google Finance - Google Sheets
@hibikidan333 - Assuming it was you who was trying this - not able to find the post this was discussed
People who were trying to build up their stock analysis on google sheets using google finance were facing issues in fetching the exact current market price. GOOGLEFINANCE(STOCKNAME) tends to round it up at 2 decimal places.
Was hacking around with the html and I was able to get the exact stock price using the following method
=IMPORTXML(CONCATENATE("https://www.google.com/finance?q=",C2),"//span[@class='pr']")
where C2 would be the Cell with the stock quote "ASX:SRT" Etc.
This gets the value until 4 decimals which should be useful when analysis penny stocks. Hope it helps & improves the stock analysis![]()
- Forums
- ASX - Short Term Trading
- Short Term Trading Week Starting: 4 Apr
Google Finance - Google Sheets @hibikidan333 - Assuming it was...
Featured News
Featured News
The Watchlist
AFP
AFT PHARMACEUTICALS LIMITED
Hartley Atkinson, CEO & Founder
Hartley Atkinson
CEO & Founder
Previous Video
Next Video
SPONSORED BY The Market Online