79247544

Date: 2024-12-03 12:15:26
Score: 0.5
Natty:
Report link

Just use

=INDEX(GOOGLEFINANCE("CURRENCY:AUDUSD", "price", DATE(2021,7,1)), 2,2)

In this function, changed QUERY(...) formula by INDEX(datatable,row,column) and removed unnecessary GOOGLEFINANCE() parameters.

INDEX

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: T77