=googlefinance(concatenate("ASX:", CELL REFERENCE ), "price")
For example for BHP in your sheet the formula would go into B2 cell and the formula would be the following:
=googlefinance(concatenate("ASX:", A2), "price")
- Forums
- General
- Google Sheets
=googlefinance(concatenate("ASX:", CELL REFERENCE ), "price")For...
-
- There are more pages in this discussion • 1 more message in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)