Do you all know a way where I can extract the exchange rate for a historic month so that I can calculate the average of it per month in one go instead of extracting each day one by one?

You can do a currency rate search to get this information

consolidated exchange rate search will give you the data you are looking for