How to get historical currency pair data from a start date to end date?

[fightthepower]

I want historical data from 2018-05-01 to 2019-05-05 of USD/INR pair. How can I do it with forex-python?

[alexfilothodoros]

Hi! I don't know if this can be done automatically, but you could write a loop where the day will be set automatically and the currency will be calculated.

[udoedo]

Hi, is this issue still open ?

[dallinb]

As an attempt off the top of my head (and with a bit of help from Stackoverflow):

from datetime import datetime
from datetime import timedelta, date
from forex_python.converter import CurrencyRates


def daterange(start_date, end_date):
    for n in range(int((end_date - start_date).days)):
        yield start_date + timedelta(n)


c = CurrencyRates()
start_date = date(2018, 5, 1)
end_date = date(2019, 5, 5)

for single_date in daterange(start_date, end_date):
    date_obj = datetime.combine(single_date, datetime.min.time())
    value = c.get_rate('USD', 'INR', date_obj)
    print(single_date.strftime('%Y-%m-%d:'), value)

Please note that this will not be kind on API rates, so either:

• Reduce the date range.
• Insert a sleep to reduce the number of calls which will take longer.

[SpectralTacos]

I was thinking along those lines, and the solution I was thinking to the API calls is after every say 5 or10 iterations (just throwing numbers out there) rest for about 2 seconds:

`from datetime import datetime, date
from time import sleep

def get_rate_history(self, base_cur, dest_cur, date_start, date_end):
lst_results = []

    num_iter_count = 0
    
    for date_iter in range(date_start.toordinal(), date_end.toordinal()):
        date_obj = datetime.combine(date_iter, datetime.min.time())
        value = get_rate(base_cur, dest_cur, date_obj)

        lst_results.append([date_iter, value])
        
        num_iter_count += 1

        if num_iter_count == 5:    #   Rest every 5 iterations
            sleep(2)
            num_iter_count = 0
        #   END if 
    #   END for

    return lst_results`

[Karlheinzniebuhr]

This would be a great feature!