Forum Discussion
Pull Yearly CAD/USD Averages Into Simple Table
I'm looking to pull in the monthly average of CAD to USD exchange rates into a nice monthly table without having to update it. I can currently pull in the daily numbers, going back a year using TODAY...
Turns out ChatGPT solved my problem! After a day of asking the wrong questions, I finally asked the right one and it spat out the formulas.
It depends on what is the data source and what is desired output. If take exchange rate with STOCKHISTORY and take average only for the trading dates in the month
it could be
=AVERAGE(STOCKHISTORY($B3, EOMONTH(C$2,-1)+1, EOMONTH(C$2, 0), 0, 0,1))- Is there a way to write this formula so that it only covers specific dates. For instance I wanted to get the average from 8/1/2024 thru 8/23/2024? Thanks
