from forex_python.converter import CurrencyRates
import datetime
import matplotlib.pyplot as plt
import plotly.express as px
import pandas as pd
https://ratesapi.io is a free API for current and historical foreign exchange rates published by European Central Bank. The rates are updated daily 3PM CET
|EUR - Euro Member Countries |IDR - Indonesia Rupiah |BGN - Bulgaria Lev |ILS - Israel Shekel |GBP - United Kingdom Pound |DKK - Denmark Krone |CAD - Canada Dollar |JPY - Japan Yen |HUF - Hungary Forint |RON - Romania New Leu |MYR - Malaysia Ringgit |SEK - Sweden Krona |SGD - Singapore Dollar |HKD - Hong Kong Dollar |AUD - Australia Dollar |CHF - Switzerland Franc |KRW - Korea (South) Won |CNY - China Yuan Renminbi |TRY - Turkey Lira |HRK - Croatia Kuna |NZD - New Zealand Dollar |THB - Thailand Baht |USD - United States Dollar |NOK - Norway Krone |RUB - Russia Ruble |INR - India Rupee |MXN - Mexico Peso |CZK - Czech Republic Koruna |BRL - Brazil Real |PLN - Poland Zloty |PHP - Philippines Peso |ZAR - South Africa Rand
c = CurrencyRates()
#c.get_rates('MYR')
#c.get_rate('USD', 'MYR')
#c.convert('MYR', 'USD', 100)
#c.get_rates('USD', datetime.datetime(2014, 5, 23, 18, 36, 28, 151012)) #List all Currency rates for “USD” on 2012-09-05
This report will summarised the finding based on Malaysian Ringgit against five selected foreign currency. There are USD, SGD, GBP, AUD and EUR. Based on this report will shows the performance and stability of the currency can be identified and summarised. The dataset was starting in year 2019 to the date of the reports.
data = {'Date':['1/1/2019','7/1/2019','14/1/2019','21/1/2019','28/1/2019',
'1/2/2019','7/2/2019','14/2/2019','21/2/2019','28/2/2019',
'1/3/2019','7/3/2019','14/3/2019','21/3/2019','28/3/2019',
'1/4/2019','7/4/2019','14/4/2019','21/4/2019','28/4/2019',
'1/5/2019','7/5/2019','14/5/2019','21/5/2019','28/5/2019',
'1/6/2019','7/6/2019','14/6/2019','21/6/2019','28/6/2019',
'1/7/2019','7/7/2019','14/7/2019','21/7/2019','28/7/2019',
'1/8/2019','7/8/2019','14/8/2019','21/8/2019','28/8/2019',
'1/9/2019','7/9/2019','14/9/2019','21/9/2019','28/9/2019',
'1/10/2019','7/10/2019','14/10/2019','21/10/2019','28/10/2019',
'1/11/2019','7/11/2019','14/11/2019','21/11/2019','28/11/2019',
'1/12/2019','7/12/2019','14/12/2019','21/12/2019','28/12/2019'],
'Currency Exchange':[c.get_rate('USD','MYR', datetime.datetime(2019, 1, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 1, 7, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 1, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 1, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 1, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 2, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 2, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 2, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 2, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 2, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 3, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 3, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 3, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 3, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 3, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 4, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 4, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 4, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 4, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 4, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 5, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 5, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 5, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 5, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 5, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 6, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 6, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 6, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 6, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 6, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 7, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 7, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 7, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 7, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 7, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 8, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 8, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 8, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 8, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 8, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 9, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 9, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 9, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 9, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 9, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 10, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 10, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 10, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 10, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 10, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2019, 11, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 11, 7, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 11, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 11, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 11, 28, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 12, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 12, 7, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 12, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 12, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2019, 12, 28, 18, 36, 28, 151012))],
}
df1_2019 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df1_2019['Date'] = pd.to_datetime(df1_2019.Date)
df1_2019['Date'] = df1_2019['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2019','7/1/2019','14/1/2019','21/1/2019','28/1/2019',
'1/2/2019','7/2/2019','14/2/2019','21/2/2019','28/2/2019',
'1/3/2019','7/3/2019','14/3/2019','21/3/2019','28/3/2019',
'1/4/2019','7/4/2019','14/4/2019','21/4/2019','28/4/2019',
'1/5/2019','7/5/2019','14/5/2019','21/5/2019','28/5/2019',
'1/6/2019','7/6/2019','14/6/2019','21/6/2019','28/6/2019',
'1/7/2019','7/7/2019','14/7/2019','21/7/2019','28/7/2019',
'1/8/2019','7/8/2019','14/8/2019','21/8/2019','28/8/2019',
'1/9/2019','7/9/2019','14/9/2019','21/9/2019','28/9/2019',
'1/10/2019','7/10/2019','14/10/2019','21/10/2019','28/10/2019',
'1/11/2019','7/11/2019','14/11/2019','21/11/2019','28/11/2019',
'1/12/2019','7/12/2019','14/12/2019','21/12/2019','28/12/2019'],
'Currency Exchange':[c.get_rate('SGD','MYR', datetime.datetime(2019, 1, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 1, 7, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 1, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 1, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 1, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 2, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 2, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 2, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 2, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 2, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 3, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 3, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 3, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 3, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 3, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 4, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 4, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 4, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 4, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 4, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 5, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 5, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 5, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 5, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 5, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 6, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 6, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 6, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 6, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 6, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 7, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 7, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 7, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 7, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 7, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 8, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 8, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 8, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 8, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 8, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 9, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 9, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 9, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 9, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 9, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 10, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 10, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 10, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 10, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 10, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2019, 11, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 11, 7, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 11, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 11, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 11, 28, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 12, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 12, 7, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 12, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 12, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2019, 12, 28, 18, 36, 28, 151012))],
}
df2_2019 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df2_2019['Date'] = pd.to_datetime(df2_2019.Date)
df2_2019['Date'] = df2_2019['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2019','7/1/2019','14/1/2019','21/1/2019','28/1/2019',
'1/2/2019','7/2/2019','14/2/2019','21/2/2019','28/2/2019',
'1/3/2019','7/3/2019','14/3/2019','21/3/2019','28/3/2019',
'1/4/2019','7/4/2019','14/4/2019','21/4/2019','28/4/2019',
'1/5/2019','7/5/2019','14/5/2019','21/5/2019','28/5/2019',
'1/6/2019','7/6/2019','14/6/2019','21/6/2019','28/6/2019',
'1/7/2019','7/7/2019','14/7/2019','21/7/2019','28/7/2019',
'1/8/2019','7/8/2019','14/8/2019','21/8/2019','28/8/2019',
'1/9/2019','7/9/2019','14/9/2019','21/9/2019','28/9/2019',
'1/10/2019','7/10/2019','14/10/2019','21/10/2019','28/10/2019',
'1/11/2019','7/11/2019','14/11/2019','21/11/2019','28/11/2019',
'1/12/2019','7/12/2019','14/12/2019','21/12/2019','28/12/2019'],
'Currency Exchange':[c.get_rate('GBP','MYR', datetime.datetime(2019, 1, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 1, 7, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 1, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 1, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 1, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 2, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 2, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 2, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 2, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 2, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 3, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 3, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 3, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 3, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 3, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 4, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 4, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 4, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 4, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 4, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 5, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 5, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 5, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 5, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 5, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 6, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 6, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 6, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 6, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 6, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 7, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 7, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 7, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 7, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 7, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 8, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 8, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 8, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 8, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 8, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 9, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 9, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 9, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 9, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 9, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 10, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 10, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 10, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 10, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 10, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2019, 11, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 11, 7, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 11, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 11, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 11, 28, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 12, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 12, 7, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 12, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 12, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2019, 12, 28, 18, 36, 28, 151012))],
}
df3_2019 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df3_2019['Date'] = pd.to_datetime(df3_2019.Date)
df3_2019['Date'] = df3_2019['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2019','7/1/2019','14/1/2019','21/1/2019','28/1/2019',
'1/2/2019','7/2/2019','14/2/2019','21/2/2019','28/2/2019',
'1/3/2019','7/3/2019','14/3/2019','21/3/2019','28/3/2019',
'1/4/2019','7/4/2019','14/4/2019','21/4/2019','28/4/2019',
'1/5/2019','7/5/2019','14/5/2019','21/5/2019','28/5/2019',
'1/6/2019','7/6/2019','14/6/2019','21/6/2019','28/6/2019',
'1/7/2019','7/7/2019','14/7/2019','21/7/2019','28/7/2019',
'1/8/2019','7/8/2019','14/8/2019','21/8/2019','28/8/2019',
'1/9/2019','7/9/2019','14/9/2019','21/9/2019','28/9/2019',
'1/10/2019','7/10/2019','14/10/2019','21/10/2019','28/10/2019',
'1/11/2019','7/11/2019','14/11/2019','21/11/2019','28/11/2019',
'1/12/2019','7/12/2019','14/12/2019','21/12/2019','28/12/2019'],
'Currency Exchange':[c.get_rate('AUD','MYR', datetime.datetime(2019, 1, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 1, 7, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 1, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 1, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 1, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 2, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 2, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 2, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 2, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 2, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 3, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 3, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 3, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 3, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 3, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 4, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 4, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 4, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 4, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 4, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 5, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 5, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 5, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 5, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 5, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 6, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 6, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 6, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 6, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 6, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 7, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 7, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 7, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 7, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 7, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 8, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 8, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 8, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 8, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 8, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 9, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 9, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 9, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 9, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 9, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 10, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 10, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 10, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 10, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 10, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2019, 11, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 11, 7, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 11, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 11, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 11, 28, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 12, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 12, 7, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 12, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 12, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2019, 12, 28, 18, 36, 28, 151012))],
}
df4_2019 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df4_2019['Date'] = pd.to_datetime(df4_2019.Date)
df4_2019['Date'] = df4_2019['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2019','7/1/2019','14/1/2019','21/1/2019','28/1/2019',
'1/2/2019','7/2/2019','14/2/2019','21/2/2019','28/2/2019',
'1/3/2019','7/3/2019','14/3/2019','21/3/2019','28/3/2019',
'1/4/2019','7/4/2019','14/4/2019','21/4/2019','28/4/2019',
'1/5/2019','7/5/2019','14/5/2019','21/5/2019','28/5/2019',
'1/6/2019','7/6/2019','14/6/2019','21/6/2019','28/6/2019',
'1/7/2019','7/7/2019','14/7/2019','21/7/2019','28/7/2019',
'1/8/2019','7/8/2019','14/8/2019','21/8/2019','28/8/2019',
'1/9/2019','7/9/2019','14/9/2019','21/9/2019','28/9/2019',
'1/10/2019','7/10/2019','14/10/2019','21/10/2019','28/10/2019',
'1/11/2019','7/11/2019','14/11/2019','21/11/2019','28/11/2019',
'1/12/2019','7/12/2019','14/12/2019','21/12/2019','28/12/2019'],
'Currency Exchange':[c.get_rate('EUR','MYR', datetime.datetime(2019, 1, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 1, 7, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 1, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 1, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 1, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 2, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 2, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 2, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 2, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 2, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 3, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 3, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 3, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 3, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 3, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 4, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 4, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 4, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 4, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 4, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 5, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 5, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 5, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 5, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 5, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 6, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 6, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 6, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 6, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 6, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 7, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 7, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 7, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 7, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 7, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 8, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 8, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 8, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 8, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 8, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 9, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 9, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 9, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 9, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 9, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 10, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 10, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 10, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 10, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 10, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2019, 11, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 11, 7, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 11, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 11, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 11, 28, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 12, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 12, 7, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 12, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 12, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2019, 12, 28, 18, 36, 28, 151012))],
}
df5_2019 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df5_2019['Date'] = pd.to_datetime(df5_2019.Date)
df5_2019['Date'] = df5_2019['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2020','7/1/2020','14/1/2020','21/1/2020','28/1/2020',
'1/2/2020','7/2/2020','14/2/2020','21/2/2020','28/2/2020',
'1/3/2020','7/3/2020','14/3/2020','21/3/2020','28/3/2020',
'1/4/2020','7/4/2020','14/4/2020','21/4/2020','28/4/2020',
'1/5/2020','7/5/2020','14/5/2020','21/5/2020','28/5/2020',
'1/6/2020','7/6/2020','14/6/2020','21/6/2020','28/6/2020',
'1/7/2020','7/7/2020','14/7/2020','21/7/2020','28/7/2020',
'1/8/2020','7/8/2020','14/8/2020','21/8/2020','28/8/2020',
'1/9/2020','7/9/2020','14/9/2020','21/9/2020','28/9/2020',
'1/10/2020','7/10/2020','14/10/2020','21/10/2020','28/10/2020',
'1/11/2020','7/11/2020','14/11/2020','21/11/2020','28/11/2020',
'1/12/2020','7/12/2020','14/12/2020','21/12/2020','28/12/2020'],
'Currency Exchange':[c.get_rate('USD','MYR', datetime.datetime(2020, 1, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 1, 7, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 1, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 1, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 1, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 2, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 2, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 2, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 2, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 2, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 3, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 3, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 3, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 3, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 3, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 4, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 4, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 4, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 4, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 4, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 5, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 5, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 5, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 5, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 5, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 6, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 6, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 6, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 6, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 6, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 7, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 7, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 7, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 7, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 7, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 8, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 8, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 8, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 8, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 8, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 9, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 9, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 9, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 9, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 9, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 10, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 10, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 10, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 10, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 10, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2020, 11, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 11, 7, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 11, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 11, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 11, 28, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 12, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 12, 7, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 12, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 12, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2020, 12, 28, 18, 36, 28, 151012))],
}
df1_2020 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df1_2020['Date'] = pd.to_datetime(df1_2020.Date)
df1_2020['Date'] = df1_2020['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2020','7/1/2020','14/1/2020','21/1/2020','28/1/2020',
'1/2/2020','7/2/2020','14/2/2020','21/2/2020','28/2/2020',
'1/3/2020','7/3/2020','14/3/2020','21/3/2020','28/3/2020',
'1/4/2020','7/4/2020','14/4/2020','21/4/2020','28/4/2020',
'1/5/2020','7/5/2020','14/5/2020','21/5/2020','28/5/2020',
'1/6/2020','7/6/2020','14/6/2020','21/6/2020','28/6/2020',
'1/7/2020','7/7/2020','14/7/2020','21/7/2020','28/7/2020',
'1/8/2020','7/8/2020','14/8/2020','21/8/2020','28/8/2020',
'1/9/2020','7/9/2020','14/9/2020','21/9/2020','28/9/2020',
'1/10/2020','7/10/2020','14/10/2020','21/10/2020','28/10/2020',
'1/11/2020','7/11/2020','14/11/2020','21/11/2020','28/11/2020',
'1/12/2020','7/12/2020','14/12/2020','21/12/2020','28/12/2020'],
'Currency Exchange':[c.get_rate('SGD','MYR', datetime.datetime(2020, 1, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 1, 7, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 1, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 1, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 1, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 2, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 2, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 2, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 2, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 2, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 3, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 3, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 3, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 3, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 3, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 4, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 4, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 4, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 4, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 4, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 5, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 5, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 5, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 5, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 5, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 6, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 6, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 6, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 6, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 6, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 7, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 7, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 7, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 7, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 7, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 8, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 8, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 8, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 8, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 8, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 9, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 9, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 9, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 9, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 9, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 10, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 10, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 10, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 10, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 10, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2020, 11, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 11, 7, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 11, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 11, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 11, 28, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 12, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 12, 7, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 12, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 12, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2020, 12, 28, 18, 36, 28, 151012))],
}
df2_2020 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df2_2020['Date'] = pd.to_datetime(df2_2020.Date)
df2_2020['Date'] = df2_2020['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2020','7/1/2020','14/1/2020','21/1/2020','28/1/2020',
'1/2/2020','7/2/2020','14/2/2020','21/2/2020','28/2/2020',
'1/3/2020','7/3/2020','14/3/2020','21/3/2020','28/3/2020',
'1/4/2020','7/4/2020','14/4/2020','21/4/2020','28/4/2020',
'1/5/2020','7/5/2020','14/5/2020','21/5/2020','28/5/2020',
'1/6/2020','7/6/2020','14/6/2020','21/6/2020','28/6/2020',
'1/7/2020','7/7/2020','14/7/2020','21/7/2020','28/7/2020',
'1/8/2020','7/8/2020','14/8/2020','21/8/2020','28/8/2020',
'1/9/2020','7/9/2020','14/9/2020','21/9/2020','28/9/2020',
'1/10/2020','7/10/2020','14/10/2020','21/10/2020','28/10/2020',
'1/11/2020','7/11/2020','14/11/2020','21/11/2020','28/11/2020',
'1/12/2020','7/12/2020','14/12/2020','21/12/2020','28/12/2020'],
'Currency Exchange':[c.get_rate('GBP','MYR', datetime.datetime(2020, 1, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 1, 7, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 1, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 1, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 1, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 2, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 2, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 2, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 2, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 2, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 3, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 3, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 3, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 3, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 3, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 4, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 4, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 4, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 4, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 4, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 5, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 5, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 5, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 5, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 5, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 6, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 6, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 6, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 6, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 6, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 7, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 7, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 7, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 7, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 7, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 8, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 8, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 8, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 8, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 8, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 9, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 9, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 9, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 9, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 9, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 10, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 10, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 10, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 10, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 10, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2020, 11, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 11, 7, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 11, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 11, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 11, 28, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 12, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 12, 7, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 12, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 12, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2020, 12, 28, 18, 36, 28, 151012))],
}
df3_2020 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df3_2020['Date'] = pd.to_datetime(df3_2020.Date)
df3_2020['Date'] = df3_2020['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2020','7/1/2020','14/1/2020','21/1/2020','28/1/2020',
'1/2/2020','7/2/2020','14/2/2020','21/2/2020','28/2/2020',
'1/3/2020','7/3/2020','14/3/2020','21/3/2020','28/3/2020',
'1/4/2020','7/4/2020','14/4/2020','21/4/2020','28/4/2020',
'1/5/2020','7/5/2020','14/5/2020','21/5/2020','28/5/2020',
'1/6/2020','7/6/2020','14/6/2020','21/6/2020','28/6/2020',
'1/7/2020','7/7/2020','14/7/2020','21/7/2020','28/7/2020',
'1/8/2020','7/8/2020','14/8/2020','21/8/2020','28/8/2020',
'1/9/2020','7/9/2020','14/9/2020','21/9/2020','28/9/2020',
'1/10/2020','7/10/2020','14/10/2020','21/10/2020','28/10/2020',
'1/11/2020','7/11/2020','14/11/2020','21/11/2020','28/11/2020',
'1/12/2020','7/12/2020','14/12/2020','21/12/2020','28/12/2020'],
'Currency Exchange':[c.get_rate('AUD','MYR', datetime.datetime(2020, 1, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 1, 7, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 1, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 1, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 1, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 2, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 2, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 2, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 2, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 2, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 3, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 3, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 3, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 3, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 3, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 4, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 4, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 4, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 4, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 4, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 5, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 5, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 5, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 5, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 5, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 6, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 6, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 6, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 6, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 6, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 7, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 7, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 7, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 7, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 7, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 8, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 8, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 8, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 8, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 8, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 9, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 9, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 9, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 9, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 9, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 10, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 10, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 10, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 10, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 10, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2020, 11, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 11, 7, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 11, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 11, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 11, 28, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 12, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 12, 7, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 12, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 12, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2020, 12, 28, 18, 36, 28, 151012))],
}
df4_2020 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df4_2020['Date'] = pd.to_datetime(df4_2020.Date)
df4_2020['Date'] = df4_2020['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2020','7/1/2020','14/1/2020','21/1/2020','28/1/2020',
'1/2/2020','7/2/2020','14/2/2020','21/2/2020','28/2/2020',
'1/3/2020','7/3/2020','14/3/2020','21/3/2020','28/3/2020',
'1/4/2020','7/4/2020','14/4/2020','21/4/2020','28/4/2020',
'1/5/2020','7/5/2020','14/5/2020','21/5/2020','28/5/2020',
'1/6/2020','7/6/2020','14/6/2020','21/6/2020','28/6/2020',
'1/7/2020','7/7/2020','14/7/2020','21/7/2020','28/7/2020',
'1/8/2020','7/8/2020','14/8/2020','21/8/2020','28/8/2020',
'1/9/2020','7/9/2020','14/9/2020','21/9/2020','28/9/2020',
'1/10/2020','7/10/2020','14/10/2020','21/10/2020','28/10/2020',
'1/11/2020','7/11/2020','14/11/2020','21/11/2020','28/11/2020',
'1/12/2020','7/12/2020','14/12/2020','21/12/2020','28/12/2020'],
'Currency Exchange':[c.get_rate('EUR','MYR', datetime.datetime(2020, 1, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 1, 7, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 1, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 1, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 1, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 2, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 2, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 2, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 2, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 2, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 3, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 3, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 3, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 3, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 3, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 4, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 4, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 4, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 4, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 4, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 5, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 5, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 5, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 5, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 5, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 6, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 6, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 6, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 6, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 6, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 7, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 7, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 7, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 7, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 7, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 8, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 8, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 8, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 8, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 8, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 9, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 9, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 9, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 9, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 9, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 10, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 10, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 10, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 10, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 10, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2020, 11, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 11, 7, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 11, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 11, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 11, 28, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 12, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 12, 7, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 12, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 12, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2020, 12, 28, 18, 36, 28, 151012))],
}
df5_2020 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df5_2020['Date'] = pd.to_datetime(df5_2020.Date)
df5_2020['Date'] = df5_2020['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2021','7/1/2021','14/1/2021','21/1/2021','28/1/2021',
'1/2/2021','7/2/2021','14/2/2021','21/2/2021','28/2/2021',
'1/3/2021','7/3/2021','14/3/2021','21/3/2021','28/3/2021',
'1/4/2021','7/4/2021','14/4/2021','21/4/2021','28/4/2021',
'1/5/2021','7/5/2021','14/5/2021','21/5/2021','28/5/2021',
'1/6/2021','7/6/2021','14/6/2021','21/6/2021','28/6/2021',
'1/7/2021','7/7/2021','14/7/2021','21/7/2021','28/7/2021',
'1/8/2021','7/8/2021','14/8/2021','21/8/2021','28/8/2021',
'1/9/2021','7/9/2021','14/9/2021','21/9/2021','28/9/2021',
'1/10/2021','7/10/2021','14/10/2021','21/10/2021','28/10/2021',
'1/11/2021','7/11/2021','14/11/2021','21/11/2021','28/11/2021',
'1/12/2021','7/12/2021','14/12/2021','21/12/2021','28/12/2021'],
'Currency Exchange':[c.get_rate('USD','MYR', datetime.datetime(2021, 1, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 1, 7, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 1, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 1, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 1, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 2, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 2, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 2, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 2, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 2, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 3, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 3, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 3, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 3, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 3, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 4, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 4, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 4, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 4, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 4, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 5, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 5, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 5, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 5, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 5, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 6, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 6, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 6, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 6, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 6, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 7, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 7, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 7, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 7, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 7, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 8, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 8, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 8, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 8, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 8, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 9, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 9, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 9, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 9, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 9, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 10, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 10, 7, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 10, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 10, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 10, 28, 18, 36, 28, 151012)),
c.get_rate('USD', 'MYR', datetime.datetime(2021, 11, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 11, 7, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 11, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 11, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 11, 28, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 12, 1, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 12, 7, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 12, 14, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 12, 21, 18, 36, 28, 151012)),
c.get_rate('USD','MYR', datetime.datetime(2021, 12, 28, 18, 36, 28, 151012))],
}
df1_2021 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df1_2021['Date'] = pd.to_datetime(df1_2021.Date)
df1_2021['Date'] = df1_2021['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2021','7/1/2021','14/1/2021','21/1/2021','28/1/2021',
'1/2/2021','7/2/2021','14/2/2021','21/2/2021','28/2/2021',
'1/3/2021','7/3/2021','14/3/2021','21/3/2021','28/3/2021',
'1/4/2021','7/4/2021','14/4/2021','21/4/2021','28/4/2021',
'1/5/2021','7/5/2021','14/5/2021','21/5/2021','28/5/2021',
'1/6/2021','7/6/2021','14/6/2021','21/6/2021','28/6/2021',
'1/7/2021','7/7/2021','14/7/2021','21/7/2021','28/7/2021',
'1/8/2021','7/8/2021','14/8/2021','21/8/2021','28/8/2021',
'1/9/2021','7/9/2021','14/9/2021','21/9/2021','28/9/2021',
'1/10/2021','7/10/2021','14/10/2021','21/10/2021','28/10/2021',
'1/11/2021','7/11/2021','14/11/2021','21/11/2021','28/11/2021',
'1/12/2021','7/12/2021','14/12/2021','21/12/2021','28/12/2021'],
'Currency Exchange':[c.get_rate('SGD','MYR', datetime.datetime(2021, 1, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 1, 7, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 1, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 1, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 1, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 2, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 2, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 2, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 2, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 2, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 3, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 3, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 3, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 3, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 3, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 4, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 4, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 4, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 4, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 4, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 5, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 5, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 5, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 5, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 5, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 6, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 6, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 6, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 6, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 6, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 7, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 7, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 7, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 7, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 7, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 8, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 8, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 8, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 8, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 8, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 9, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 9, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 9, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 9, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 9, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 10, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 10, 7, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 10, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 10, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 10, 28, 18, 36, 28, 151012)),
c.get_rate('SGD', 'MYR', datetime.datetime(2021, 11, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 11, 7, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 11, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 11, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 11, 28, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 12, 1, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 12, 7, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 12, 14, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 12, 21, 18, 36, 28, 151012)),
c.get_rate('SGD','MYR', datetime.datetime(2021, 12, 28, 18, 36, 28, 151012))],
}
df2_2021 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df2_2021['Date'] = pd.to_datetime(df2_2021.Date)
df2_2021['Date'] = df2_2021['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2021','7/1/2021','14/1/2021','21/1/2021','28/1/2021',
'1/2/2021','7/2/2021','14/2/2021','21/2/2021','28/2/2021',
'1/3/2021','7/3/2021','14/3/2021','21/3/2021','28/3/2021',
'1/4/2021','7/4/2021','14/4/2021','21/4/2021','28/4/2021',
'1/5/2021','7/5/2021','14/5/2021','21/5/2021','28/5/2021',
'1/6/2021','7/6/2021','14/6/2021','21/6/2021','28/6/2021',
'1/7/2021','7/7/2021','14/7/2021','21/7/2021','28/7/2021',
'1/8/2021','7/8/2021','14/8/2021','21/8/2021','28/8/2021',
'1/9/2021','7/9/2021','14/9/2021','21/9/2021','28/9/2021',
'1/10/2021','7/10/2021','14/10/2021','21/10/2021','28/10/2021',
'1/11/2021','7/11/2021','14/11/2021','21/11/2021','28/11/2021',
'1/12/2021','7/12/2021','14/12/2021','21/12/2021','28/12/2021'],
'Currency Exchange':[c.get_rate('GBP','MYR', datetime.datetime(2021, 1, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 1, 7, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 1, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 1, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 1, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 2, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 2, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 2, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 2, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 2, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 3, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 3, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 3, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 3, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 3, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 4, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 4, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 4, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 4, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 4, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 5, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 5, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 5, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 5, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 5, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 6, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 6, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 6, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 6, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 6, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 7, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 7, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 7, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 7, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 7, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 8, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 8, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 8, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 8, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 8, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 9, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 9, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 9, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 9, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 9, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 10, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 10, 7, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 10, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 10, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 10, 28, 18, 36, 28, 151012)),
c.get_rate('GBP', 'MYR', datetime.datetime(2021, 11, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 11, 7, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 11, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 11, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 11, 28, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 12, 1, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 12, 7, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 12, 14, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 12, 21, 18, 36, 28, 151012)),
c.get_rate('GBP','MYR', datetime.datetime(2021, 12, 28, 18, 36, 28, 151012))],
}
df3_2021 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df3_2021['Date'] = pd.to_datetime(df3_2021.Date)
df3_2021['Date'] = df3_2021['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2021','7/1/2021','14/1/2021','21/1/2021','28/1/2021',
'1/2/2021','7/2/2021','14/2/2021','21/2/2021','28/2/2021',
'1/3/2021','7/3/2021','14/3/2021','21/3/2021','28/3/2021',
'1/4/2021','7/4/2021','14/4/2021','21/4/2021','28/4/2021',
'1/5/2021','7/5/2021','14/5/2021','21/5/2021','28/5/2021',
'1/6/2021','7/6/2021','14/6/2021','21/6/2021','28/6/2021',
'1/7/2021','7/7/2021','14/7/2021','21/7/2021','28/7/2021',
'1/8/2021','7/8/2021','14/8/2021','21/8/2021','28/8/2021',
'1/9/2021','7/9/2021','14/9/2021','21/9/2021','28/9/2021',
'1/10/2021','7/10/2021','14/10/2021','21/10/2021','28/10/2021',
'1/11/2021','7/11/2021','14/11/2021','21/11/2021','28/11/2021',
'1/12/2021','7/12/2021','14/12/2021','21/12/2021','28/12/2021'],
'Currency Exchange':[c.get_rate('AUD','MYR', datetime.datetime(2021, 1, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 1, 7, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 1, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 1, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 1, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 2, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 2, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 2, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 2, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 2, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 3, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 3, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 3, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 3, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 3, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 4, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 4, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 4, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 4, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 4, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 5, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 5, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 5, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 5, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 5, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 6, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 6, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 6, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 6, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 6, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 7, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 7, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 7, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 7, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 7, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 8, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 8, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 8, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 8, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 8, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 9, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 9, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 9, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 9, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 9, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 10, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 10, 7, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 10, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 10, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 10, 28, 18, 36, 28, 151012)),
c.get_rate('AUD', 'MYR', datetime.datetime(2021, 11, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 11, 7, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 11, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 11, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 11, 28, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 12, 1, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 12, 7, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 12, 14, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 12, 21, 18, 36, 28, 151012)),
c.get_rate('AUD','MYR', datetime.datetime(2021, 12, 28, 18, 36, 28, 151012))],
}
df4_2021 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df4_2021['Date'] = pd.to_datetime(df4_2021.Date)
df4_2021['Date'] = df4_2021['Date'].dt.strftime('%m/%d/%Y')
data = {'Date':['1/1/2021','7/1/2021','14/1/2021','21/1/2021','28/1/2021',
'1/2/2021','7/2/2021','14/2/2021','21/2/2021','28/2/2021',
'1/3/2021','7/3/2021','14/3/2021','21/3/2021','28/3/2021',
'1/4/2021','7/4/2021','14/4/2021','21/4/2021','28/4/2021',
'1/5/2021','7/5/2021','14/5/2021','21/5/2021','28/5/2021',
'1/6/2021','7/6/2021','14/6/2021','21/6/2021','28/6/2021',
'1/7/2021','7/7/2021','14/7/2021','21/7/2021','28/7/2021',
'1/8/2021','7/8/2021','14/8/2021','21/8/2021','28/8/2021',
'1/9/2021','7/9/2021','14/9/2021','21/9/2021','28/9/2021',
'1/10/2021','7/10/2021','14/10/2021','21/10/2021','28/10/2021',
'1/11/2021','7/11/2021','14/11/2021','21/11/2021','28/11/2021',
'1/12/2021','7/12/2021','14/12/2021','21/12/2021','28/12/2021'],
'Currency Exchange':[c.get_rate('EUR','MYR', datetime.datetime(2021, 1, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 1, 7, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 1, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 1, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 1, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 2, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 2, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 2, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 2, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 2, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 3, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 3, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 3, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 3, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 3, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 4, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 4, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 4, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 4, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 4, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 5, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 5, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 5, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 5, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 5, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 6, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 6, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 6, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 6, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 6, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 7, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 7, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 7, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 7, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 7, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 8, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 8, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 8, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 8, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 8, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 9, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 9, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 9, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 9, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 9, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 10, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 10, 7, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 10, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 10, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 10, 28, 18, 36, 28, 151012)),
c.get_rate('EUR', 'MYR', datetime.datetime(2021, 11, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 11, 7, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 11, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 11, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 11, 28, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 12, 1, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 12, 7, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 12, 14, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 12, 21, 18, 36, 28, 151012)),
c.get_rate('EUR','MYR', datetime.datetime(2021, 12, 28, 18, 36, 28, 151012))],
}
df5_2021 = pd.DataFrame(data,columns=['Date','Currency Exchange'])
df5_2021['Date'] = pd.to_datetime(df5_2021.Date)
df5_2021['Date'] = df5_2021['Date'].dt.strftime('%m/%d/%Y')
import plotly.graph_objects as go
from plotly.subplots import make_subplots
# Create figure with secondary y-axis
fig = make_subplots(specs=[[{"secondary_y": True}]])
# Add traces
fig.add_trace(
go.Scatter(x=df1_2019['Date'], y=df1_2019['Currency Exchange'], name="MYR VS USD"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df2_2019['Date'], y=df2_2019['Currency Exchange'], name="MYR VS SGD"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df3_2019['Date'], y=df3_2019['Currency Exchange'], name="MYR VS GBP"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df4_2019['Date'], y=df4_2019['Currency Exchange'], name="MYR VS AUD"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df5_2019['Date'], y=df5_2019['Currency Exchange'], name="MYR VS EUR"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df1_2020['Date'], y=df1_2020['Currency Exchange'], name="MYR VS USD"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df2_2020['Date'], y=df2_2020['Currency Exchange'], name="MYR VS SGD"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df3_2020['Date'], y=df3_2020['Currency Exchange'], name="MYR VS GBP"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df4_2020['Date'], y=df4_2020['Currency Exchange'], name="MYR VS AUD"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df5_2020['Date'], y=df5_2020['Currency Exchange'], name="MYR VS EUR"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df1_2021['Date'], y=df1_2021['Currency Exchange'], name="MYR VS EUR"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df2_2021['Date'], y=df2_2021['Currency Exchange'], name="MYR VS SGD"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df3_2021['Date'], y=df3_2021['Currency Exchange'], name="MYR VS GBP"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df4_2021['Date'], y=df4_2021['Currency Exchange'], name="MYR VS AUD"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df5_2021['Date'], y=df5_2021['Currency Exchange'], name="MYR VS EUR"),
secondary_y=False,
)
# Add figure title
fig.update_layout(
title_text="MYR Currency Exchange Between USD, GBP, AUD, EUR & SGD From 2019 to 2021"
)
# Set x-axis title
fig.update_xaxes(title_text="Currency Exchange Date")
# Set y-axes titles
fig.update_yaxes(title_text="Currency Exchange Values (RM)", secondary_y=False)
fig.show()
import plotly.graph_objects as go
from plotly.subplots import make_subplots
# Create figure with secondary y-axis
fig = make_subplots(specs=[[{"secondary_y": True}]])
# Add traces
fig.add_trace(
go.Scatter(x=df1_2019['Date'], y=df1_2019['Currency Exchange'], name="2019"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df1_2020['Date'], y=df1_2020['Currency Exchange'], name="2020"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df1_2021['Date'], y=df1_2021['Currency Exchange'], name="2021"),
secondary_y=False,
)
# Add figure title
fig.update_layout(
title_text="MYR VS USD Currency Exchange From 2019 to 2021"
)
# Add horizontal line
fig.add_hline(y=df1_2019['Currency Exchange'].mean(), line_dash="dot",line_color="blue",
annotation_text="Average baseline year 2019",
annotation_position="bottom right")
fig.add_hline(y=df1_2020['Currency Exchange'].mean(), line_dash="dot",line_color="red",
annotation_text="Average baseline year 2020",
annotation_position="bottom right")
fig.add_hline(y=df1_2021['Currency Exchange'].mean(), line_dash="dot",line_color="red",
annotation_text="Average baseline year 2021",
annotation_position="bottom right")
# Set x-axis title
fig.update_xaxes(title_text="Currency Exchange Date")
# Set y-axes titles
fig.update_yaxes(title_text="Currency Exchange Values (RM)", secondary_y=False)
fig.show()
import plotly.graph_objects as go
from plotly.subplots import make_subplots
# Create figure with secondary y-axis
fig = make_subplots(specs=[[{"secondary_y": True}]])
# Add traces
fig.add_trace(
go.Scatter(x=df2_2019['Date'], y=df2_2019['Currency Exchange'], name="2019"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df2_2020['Date'], y=df2_2020['Currency Exchange'], name="2020"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df2_2021['Date'], y=df2_2021['Currency Exchange'], name="2021"),
secondary_y=False,
)
# Add figure title
fig.update_layout(
title_text="MYR VS SGD Currency Exchange From 2019 to 2021"
)
# Add horizontal line
fig.add_hline(y=df2_2019['Currency Exchange'].mean(), line_dash="dot",line_color="blue",
annotation_text="Average baseline year 2019",
annotation_position="bottom right")
fig.add_hline(y=df2_2020['Currency Exchange'].mean(), line_dash="dot",line_color="red",
annotation_text="Average baseline year 2020",
annotation_position="bottom right")
fig.add_hline(y=df2_2021['Currency Exchange'].mean(), line_dash="dot",line_color="red",
annotation_text="Average baseline year 2021",
annotation_position="bottom right")
# Set x-axis title
fig.update_xaxes(title_text="Currency Exchange Date")
# Set y-axes titles
fig.update_yaxes(title_text="Currency Exchange Values (RM)", secondary_y=False)
fig.show()
import plotly.graph_objects as go
from plotly.subplots import make_subplots
# Create figure with secondary y-axis
fig = make_subplots(specs=[[{"secondary_y": True}]])
# Add traces
fig.add_trace(
go.Scatter(x=df3_2019['Date'], y=df3_2019['Currency Exchange'], name="2019"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df3_2020['Date'], y=df3_2020['Currency Exchange'], name="2020"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df3_2021['Date'], y=df3_2021['Currency Exchange'], name="2021"),
secondary_y=False,
)
# Add figure title
fig.update_layout(
title_text="MYR VS GBP Currency Exchange From 2019 to 2021"
)
# Add horizontal line
fig.add_hline(y=df3_2019['Currency Exchange'].mean(), line_dash="dot",line_color="blue",
annotation_text="Average baseline year 2019",
annotation_position="bottom right")
fig.add_hline(y=df3_2020['Currency Exchange'].mean(), line_dash="dot",line_color="red",
annotation_text="Average baseline year 2020",
annotation_position="bottom right")
fig.add_hline(y=df3_2021['Currency Exchange'].mean(), line_dash="dot",line_color="red",
annotation_text="Average baseline year 2021",
annotation_position="bottom right")
# Set x-axis title
fig.update_xaxes(title_text="Currency Exchange Date")
# Set y-axes titles
fig.update_yaxes(title_text="Currency Exchange Values (RM)", secondary_y=False)
fig.show()
import plotly.graph_objects as go
from plotly.subplots import make_subplots
# Create figure with secondary y-axis
fig = make_subplots(specs=[[{"secondary_y": True}]])
# Add traces
fig.add_trace(
go.Scatter(x=df4_2019['Date'], y=df4_2019['Currency Exchange'], name="2019"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df4_2020['Date'], y=df4_2020['Currency Exchange'], name="2020"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df4_2021['Date'], y=df4_2021['Currency Exchange'], name="2021"),
secondary_y=False,
)
# Add figure title
fig.update_layout(
title_text="MYR VS AUD Currency Exchange From 2019 to 2021"
)
# Add horizontal line
fig.add_hline(y=df4_2019['Currency Exchange'].mean(), line_dash="dot",line_color="blue",
annotation_text="Average baseline year 2019",
annotation_position="bottom right")
fig.add_hline(y=df4_2020['Currency Exchange'].mean(), line_dash="dot",line_color="red",
annotation_text="Average baseline year 2020",
annotation_position="bottom right")
fig.add_hline(y=df4_2021['Currency Exchange'].mean(), line_dash="dot",line_color="red",
annotation_text="Average baseline year 2021",
annotation_position="bottom right")
# Set x-axis title
fig.update_xaxes(title_text="Currency Exchange Date")
# Set y-axes titles
fig.update_yaxes(title_text="Currency Exchange Values (RM)", secondary_y=False)
fig.show()
import plotly.graph_objects as go
from plotly.subplots import make_subplots
# Create figure with secondary y-axis
fig = make_subplots(specs=[[{"secondary_y": True}]])
# Add traces
fig.add_trace(
go.Scatter(x=df5_2019['Date'], y=df5_2019['Currency Exchange'], name="2019"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df5_2020['Date'], y=df5_2020['Currency Exchange'], name="2020"),
secondary_y=False,
)
fig.add_trace(
go.Scatter(x=df5_2021['Date'], y=df5_2021['Currency Exchange'], name="2021"),
secondary_y=False,
)
# Add figure title
fig.update_layout(
title_text="MYR VS EUR Currency Exchange From 2019 to 2021"
)
# Add horizontal line
fig.add_hline(y=df5_2019['Currency Exchange'].mean(), line_dash="dot",line_color="blue",
annotation_text="Average baseline year 2019",
annotation_position="bottom right")
fig.add_hline(y=df5_2020['Currency Exchange'].mean(), line_dash="dot",line_color="red",
annotation_text="Average baseline year 2020",
annotation_position="bottom right")
fig.add_hline(y=df5_2021['Currency Exchange'].mean(), line_dash="dot",line_color="red",
annotation_text="Average baseline year 2021",
annotation_position="bottom right")
# Set x-axis title
fig.update_xaxes(title_text="Currency Exchange Date")
# Set y-axes titles
fig.update_yaxes(title_text="Currency Exchange Values (RM)", secondary_y=False)
fig.show()