concretesubmarine.com/ FORUM

Members Login
Username 
 
Password 
    Remember Me  
Mainsite -> concretesubmarine.com/ FORUM -> Seasteading Themes -> Pull Yearly CAD/USD Averages Into Simple Table
Post Info TOPIC: Pull Yearly CAD/USD Averages Into Simple Table
DennVafla


Senior Member

Status: Offline
Posts: 263
Date:
Pull Yearly CAD/USD Averages Into Simple Table
Permalink   
 

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()-365, but I'd like to now take those columns, average them according to month, and then have them pull into a table on the main sheet. The issue I'm running into is the data will change from day to day, so the formulas will need to take that into account, as well as having Dec-2022 and Dec-2023 in the same data list. I was thinking of using the =IF() formula, but can't think how to make it work. Any help would be great!



__________________
SaymonSax


Senior Member

Status: Offline
Posts: 187
Date:
Permalink   
 

That’s a really cool project! I ran into something similar when I was tracking expenses for a project involving currency payments Dubai real estate. Timing the payments right was crucial because even small changes in the CAD/USD rate could make a big difference. Owners Club FX had some great advice about managing exchange rate fluctuations, which helped me plan better.

For your table, you might want to use a combination of SUMIFS and COUNTIFS to calculate the monthly averages dynamically. You could create a helper column to extract the year and month from the date, then use those as criteria in your formulas. That way, the averages will adjust automatically as the data updates.



__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
Mainsite -> concretesubmarine.com/ FORUM -> Seasteading Themes -> Pull Yearly CAD/USD Averages Into Simple Table


Create your own FREE Forum
Report Abuse 		Powered by ActiveBoard