Short Term Trading Week Starting: 4 Apr, page-467

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