79292893

Date: 2024-12-19 01:27:20
Score: 3
Natty:
Report link

Thanks, all. I was able to get the following to work well:

=SCAN(0, query(GOOGLEFINANCE("SPX","price",TODAY()-365,TODAY()), "Select Col2 offset 1",0), LAMBDA(currmax,value,MAX(currmax,value)))

Credit to https://support.google.com/profile/24340643...

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Low length (0.5):
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: LawnBob