Google Sheets Formula Modification
Budget: $10 – $30 CAD
Hi there, I'm working with google sheets to run "googlefinance" function.
Here's a sample function:
=query(GoogleFinance("nasdaq:goog", "price", "1/3/2022"))
It returns results as a table that looks like this:
Date: Close:
1/3/2022 145.07
For my spreadsheet, I don't need the table headings or the date - 3 of the 4 cells I don't want. ("Date:", "Close:", "1/3/2022")
I only need the result (1 cell): "145.07".
I'm looking for someone to modify this function in Google sheets to only return the result, to the cell where the function is performed.
Here's a sample function:
=query(GoogleFinance("nasdaq:goog", "price", "1/3/2022"))
It returns results as a table that looks like this:
Date: Close:
1/3/2022 145.07
For my spreadsheet, I don't need the table headings or the date - 3 of the 4 cells I don't want. ("Date:", "Close:", "1/3/2022")
I only need the result (1 cell): "145.07".
I'm looking for someone to modify this function in Google sheets to only return the result, to the cell where the function is performed.