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...
I think I got it. =AVERAGE(STOCKHISTORY($B4, DATE(2024,8,1)+1, DATE(2024,8,23), 0, 0,1))
Yes, something like this. The only DATE(2024,8,1) if first date is Aug 1st. Please not, only trading dates are returned. If, for example, you'd like to take exchange rate from Sep 01 to Sep 01 and error will be returned since 01st is not the trading date.
From Sep 01 to Sep 08 only exchange rates from Sep 02 to Sep 06 are returned.
If weekends and bank holidays are to be covered, that's also possible but formula will be more complicated.