adhoc_exchange_rates.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "b27d0f1b",
   "metadata": {},
   "outputs": [],
   "source": [
    "#import all necessary libraries\n",
    "import json\n",
    "from ExchangeRateEvent import *\n",
    "from get_currencies import *\n",
    "from constants import API_URL, BASE_CURRENCY, LOCAL_CURRENCIES, SALESFORCE_INSTANCE_URL, SALESFORCE_API_USER, SALESFORCE_API_PASS, SALESFORCE_API_TOKEN, DB_URL\n",
    "import logging\n",
    "import os\n",
    "import sys\n",
    "from datetime import timedelta, date\n",
    "import datetime\n",
    "import pandas as pd\n",
    "from file_opener import *\n",
    "from simple_salesforce import Salesforce\n",
    "from dateutil.parser import parse"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d8d31b15-28da-4910-b2a1-f47a91423293",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<>:2: SyntaxWarning: invalid escape sequence '\\.'\n",
      "<>:2: SyntaxWarning: invalid escape sequence '\\.'\n",
      "/var/folders/gz/65b9jhcd3hsds0mhwvdrrbbc0000gn/T/ipykernel_7398/2499133269.py:2: SyntaxWarning: invalid escape sequence '\\.'\n",
      "  sys.path.append('..\\..')\n"
     ]
    }
   ],
   "source": [
    "#Navigate and import from the submodule\n",
    "sys.path.append('..\\..')\n",
    "from data_utils.sf_connect import sf_connect\n",
    "from data_utils.file_opener import file_opener"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "907cdc26",
   "metadata": {},
   "outputs": [],
   "source": [
    "#set up parameters\n",
    "API_KEY = os.environ['API_KEY']\n",
    "file_date = datetime.datetime.now().strftime('%Y%m%d')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "77de438f",
   "metadata": {},
   "source": [
    "Run Query using Salesforce API\n",
    "Alternatively, you could download the results of the SOQL query from Data Export in Salesforce"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "fa50a12a",
   "metadata": {},
   "outputs": [],
   "source": [
    "#load in SOQL query used to pull all relevant donations\n",
    "donation_soql = file_opener('donations.soql')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "6af1b482",
   "metadata": {},
   "outputs": [],
   "source": [
    "#connect to the Salesforce API using the sf_connect.py file in the data_utils submodule\n",
    "sf = sf_connect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "100366b0-c0ac-4457-a16b-df8e78c99aaa",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Querying data from Salesforce for the opportunity object...\n",
      "Query completed.\n",
      "Parsing query results...\n",
      "Converting results to dataframe...\n",
      "Converting data types...\n",
      "Converting column Local_Currency_Amount_Number_For_Nat__c to float64...\n",
      "Converting column CloseDate to date...\n"
     ]
    }
   ],
   "source": [
    "#run the SOQL query using the API\n",
    "sf.sf_query_object(donation_soql)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c52d3a0f-29dc-4c48-a43e-b3d122606a44",
   "metadata": {},
   "outputs": [],
   "source": [
    "#save results of query as a local dataframe\n",
    "sf_donations_df = sf.data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "40a2f4fe",
   "metadata": {},
   "outputs": [],
   "source": [
    "#set up a mapping to rename the Salesforce fields locally to match CurrencyAPI field names;\n",
    "renamer = {'Id': 'opportunity_id'\n",
    "           ,'Currency__c': 'local_currency'\n",
    "           ,'Local_Currency_Amount_Number_For_Nat__c': 'local_currency_amount'\n",
    "           ,'CloseDate': 'exchange_rate_date'}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "e006a05b-0c67-488a-b9fa-322826dd0347",
   "metadata": {},
   "outputs": [],
   "source": [
    "#apply the field-renaming mapping to the dataframe, and save a list of unique donation dates locally (to help pull the minimum amount of data from the CurrencyAPI)\n",
    "if len(sf_donations_df) > 0:\n",
    "    sf_donations_df.rename(columns = renamer, inplace = True)\n",
    "    currencies_dates = sf_donations_df[['local_currency', 'exchange_rate_date']].copy().drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "2f615145",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The Salesforce returned a dataframe with 1297 records.\n"
     ]
    }
   ],
   "source": [
    "#print how many donations will need converting:\n",
    "print('The Salesforce query returned a dataframe with {} records.'.format(len(sf_donations_df)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "ef9b2b49",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/gz/65b9jhcd3hsds0mhwvdrrbbc0000gn/T/ipykernel_7398/3284135293.py:5: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
      "  local_currency = data[0]\n",
      "/var/folders/gz/65b9jhcd3hsds0mhwvdrrbbc0000gn/T/ipykernel_7398/3284135293.py:6: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
      "  date = data[1].strftime('%Y%m%d')\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14999 of 15000 requests have been made against our quota for a utilization percentage of 6.666666666665932e-05\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14998 of 15000 requests have been made against our quota for a utilization percentage of 0.00013333333333331865\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14997 of 15000 requests have been made against our quota for a utilization percentage of 0.00019999999999997797\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14996 of 15000 requests have been made against our quota for a utilization percentage of 0.0002666666666666373\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14995 of 15000 requests have been made against our quota for a utilization percentage of 0.0003333333333332966\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14994 of 15000 requests have been made against our quota for a utilization percentage of 0.00039999999999995595\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14993 of 15000 requests have been made against our quota for a utilization percentage of 0.00046666666666661527\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14992 of 15000 requests have been made against our quota for a utilization percentage of 0.0005333333333333856\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14991 of 15000 requests have been made against our quota for a utilization percentage of 0.0006000000000000449\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14990 of 15000 requests have been made against our quota for a utilization percentage of 0.0006666666666667043\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14989 of 15000 requests have been made against our quota for a utilization percentage of 0.0007333333333333636\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14988 of 15000 requests have been made against our quota for a utilization percentage of 0.0008000000000000229\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14987 of 15000 requests have been made against our quota for a utilization percentage of 0.0008666666666666822\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14986 of 15000 requests have been made against our quota for a utilization percentage of 0.0009333333333333416\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14985 of 15000 requests have been made against our quota for a utilization percentage of 0.0010000000000000009\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14984 of 15000 requests have been made against our quota for a utilization percentage of 0.0010666666666666602\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14983 of 15000 requests have been made against our quota for a utilization percentage of 0.0011333333333333195\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14982 of 15000 requests have been made against our quota for a utilization percentage of 0.0011999999999999789\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14981 of 15000 requests have been made against our quota for a utilization percentage of 0.0012666666666666382\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14980 of 15000 requests have been made against our quota for a utilization percentage of 0.0013333333333332975\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14979 of 15000 requests have been made against our quota for a utilization percentage of 0.0013999999999999568\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14978 of 15000 requests have been made against our quota for a utilization percentage of 0.0014666666666666162\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14977 of 15000 requests have been made against our quota for a utilization percentage of 0.0015333333333333865\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14976 of 15000 requests have been made against our quota for a utilization percentage of 0.0016000000000000458\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14975 of 15000 requests have been made against our quota for a utilization percentage of 0.0016666666666667052\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14974 of 15000 requests have been made against our quota for a utilization percentage of 0.0017333333333333645\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14973 of 15000 requests have been made against our quota for a utilization percentage of 0.0018000000000000238\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14972 of 15000 requests have been made against our quota for a utilization percentage of 0.0018666666666666831\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14971 of 15000 requests have been made against our quota for a utilization percentage of 0.0019333333333333425\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14970 of 15000 requests have been made against our quota for a utilization percentage of 0.0020000000000000018\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14969 of 15000 requests have been made against our quota for a utilization percentage of 0.002066666666666661\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14968 of 15000 requests have been made against our quota for a utilization percentage of 0.0021333333333333204\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14967 of 15000 requests have been made against our quota for a utilization percentage of 0.0021999999999999797\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14966 of 15000 requests have been made against our quota for a utilization percentage of 0.002266666666666639\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14965 of 15000 requests have been made against our quota for a utilization percentage of 0.0023333333333332984\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14964 of 15000 requests have been made against our quota for a utilization percentage of 0.0023999999999999577\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14963 of 15000 requests have been made against our quota for a utilization percentage of 0.002466666666666617\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14962 of 15000 requests have been made against our quota for a utilization percentage of 0.0025333333333333874\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14961 of 15000 requests have been made against our quota for a utilization percentage of 0.0026000000000000467\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14960 of 15000 requests have been made against our quota for a utilization percentage of 0.002666666666666706\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14959 of 15000 requests have been made against our quota for a utilization percentage of 0.0027333333333333654\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14958 of 15000 requests have been made against our quota for a utilization percentage of 0.0028000000000000247\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14957 of 15000 requests have been made against our quota for a utilization percentage of 0.002866666666666684\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14956 of 15000 requests have been made against our quota for a utilization percentage of 0.0029333333333333433\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14955 of 15000 requests have been made against our quota for a utilization percentage of 0.0030000000000000027\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14954 of 15000 requests have been made against our quota for a utilization percentage of 0.003066666666666662\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14953 of 15000 requests have been made against our quota for a utilization percentage of 0.0031333333333333213\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14952 of 15000 requests have been made against our quota for a utilization percentage of 0.0031999999999999806\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14951 of 15000 requests have been made against our quota for a utilization percentage of 0.00326666666666664\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14950 of 15000 requests have been made against our quota for a utilization percentage of 0.0033333333333332993\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14949 of 15000 requests have been made against our quota for a utilization percentage of 0.0033999999999999586\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14948 of 15000 requests have been made against our quota for a utilization percentage of 0.003466666666666618\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14947 of 15000 requests have been made against our quota for a utilization percentage of 0.0035333333333333883\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14946 of 15000 requests have been made against our quota for a utilization percentage of 0.0036000000000000476\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14945 of 15000 requests have been made against our quota for a utilization percentage of 0.003666666666666707\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14944 of 15000 requests have been made against our quota for a utilization percentage of 0.0037333333333333663\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14943 of 15000 requests have been made against our quota for a utilization percentage of 0.0038000000000000256\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14942 of 15000 requests have been made against our quota for a utilization percentage of 0.003866666666666685\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14941 of 15000 requests have been made against our quota for a utilization percentage of 0.003933333333333344\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14940 of 15000 requests have been made against our quota for a utilization percentage of 0.0040000000000000036\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14939 of 15000 requests have been made against our quota for a utilization percentage of 0.004066666666666663\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14938 of 15000 requests have been made against our quota for a utilization percentage of 0.004133333333333322\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14937 of 15000 requests have been made against our quota for a utilization percentage of 0.0041999999999999815\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14936 of 15000 requests have been made against our quota for a utilization percentage of 0.004266666666666641\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14935 of 15000 requests have been made against our quota for a utilization percentage of 0.0043333333333333\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14934 of 15000 requests have been made against our quota for a utilization percentage of 0.0043999999999999595\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14933 of 15000 requests have been made against our quota for a utilization percentage of 0.004466666666666619\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14932 of 15000 requests have been made against our quota for a utilization percentage of 0.004533333333333278\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14931 of 15000 requests have been made against our quota for a utilization percentage of 0.0046000000000000485\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14930 of 15000 requests have been made against our quota for a utilization percentage of 0.004666666666666708\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14929 of 15000 requests have been made against our quota for a utilization percentage of 0.004733333333333367\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14928 of 15000 requests have been made against our quota for a utilization percentage of 0.0048000000000000265\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14927 of 15000 requests have been made against our quota for a utilization percentage of 0.004866666666666686\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14926 of 15000 requests have been made against our quota for a utilization percentage of 0.004933333333333345\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14925 of 15000 requests have been made against our quota for a utilization percentage of 0.0050000000000000044\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14924 of 15000 requests have been made against our quota for a utilization percentage of 0.005066666666666664\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14923 of 15000 requests have been made against our quota for a utilization percentage of 0.005133333333333323\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14922 of 15000 requests have been made against our quota for a utilization percentage of 0.005199999999999982\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14921 of 15000 requests have been made against our quota for a utilization percentage of 0.005266666666666642\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14920 of 15000 requests have been made against our quota for a utilization percentage of 0.005333333333333301\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14919 of 15000 requests have been made against our quota for a utilization percentage of 0.00539999999999996\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14918 of 15000 requests have been made against our quota for a utilization percentage of 0.00546666666666662\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14917 of 15000 requests have been made against our quota for a utilization percentage of 0.005533333333333279\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14916 of 15000 requests have been made against our quota for a utilization percentage of 0.005600000000000049\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14915 of 15000 requests have been made against our quota for a utilization percentage of 0.005666666666666709\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14914 of 15000 requests have been made against our quota for a utilization percentage of 0.005733333333333368\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14913 of 15000 requests have been made against our quota for a utilization percentage of 0.005800000000000027\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14912 of 15000 requests have been made against our quota for a utilization percentage of 0.005866666666666687\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14911 of 15000 requests have been made against our quota for a utilization percentage of 0.005933333333333346\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14910 of 15000 requests have been made against our quota for a utilization percentage of 0.006000000000000005\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14909 of 15000 requests have been made against our quota for a utilization percentage of 0.006066666666666665\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14908 of 15000 requests have been made against our quota for a utilization percentage of 0.006133333333333324\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14907 of 15000 requests have been made against our quota for a utilization percentage of 0.006199999999999983\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14906 of 15000 requests have been made against our quota for a utilization percentage of 0.006266666666666643\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14905 of 15000 requests have been made against our quota for a utilization percentage of 0.006333333333333302\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14904 of 15000 requests have been made against our quota for a utilization percentage of 0.006399999999999961\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14903 of 15000 requests have been made against our quota for a utilization percentage of 0.006466666666666621\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14902 of 15000 requests have been made against our quota for a utilization percentage of 0.00653333333333328\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14901 of 15000 requests have been made against our quota for a utilization percentage of 0.00660000000000005\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14900 of 15000 requests have been made against our quota for a utilization percentage of 0.00666666666666671\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14899 of 15000 requests have been made against our quota for a utilization percentage of 0.006733333333333369\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14898 of 15000 requests have been made against our quota for a utilization percentage of 0.006800000000000028\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14897 of 15000 requests have been made against our quota for a utilization percentage of 0.006866666666666688\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14896 of 15000 requests have been made against our quota for a utilization percentage of 0.006933333333333347\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14895 of 15000 requests have been made against our quota for a utilization percentage of 0.007000000000000006\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14894 of 15000 requests have been made against our quota for a utilization percentage of 0.0070666666666666655\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14893 of 15000 requests have been made against our quota for a utilization percentage of 0.007133333333333325\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14892 of 15000 requests have been made against our quota for a utilization percentage of 0.007199999999999984\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14891 of 15000 requests have been made against our quota for a utilization percentage of 0.0072666666666666435\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14890 of 15000 requests have been made against our quota for a utilization percentage of 0.007333333333333303\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14889 of 15000 requests have been made against our quota for a utilization percentage of 0.007399999999999962\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14888 of 15000 requests have been made against our quota for a utilization percentage of 0.0074666666666666215\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14887 of 15000 requests have been made against our quota for a utilization percentage of 0.007533333333333281\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14886 of 15000 requests have been made against our quota for a utilization percentage of 0.007600000000000051\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14885 of 15000 requests have been made against our quota for a utilization percentage of 0.0076666666666667105\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14884 of 15000 requests have been made against our quota for a utilization percentage of 0.00773333333333337\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14883 of 15000 requests have been made against our quota for a utilization percentage of 0.007800000000000029\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14882 of 15000 requests have been made against our quota for a utilization percentage of 0.007866666666666688\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14881 of 15000 requests have been made against our quota for a utilization percentage of 0.007933333333333348\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14880 of 15000 requests have been made against our quota for a utilization percentage of 0.008000000000000007\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14879 of 15000 requests have been made against our quota for a utilization percentage of 0.008066666666666666\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14878 of 15000 requests have been made against our quota for a utilization percentage of 0.008133333333333326\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14877 of 15000 requests have been made against our quota for a utilization percentage of 0.008199999999999985\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14876 of 15000 requests have been made against our quota for a utilization percentage of 0.008266666666666644\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14875 of 15000 requests have been made against our quota for a utilization percentage of 0.008333333333333304\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14874 of 15000 requests have been made against our quota for a utilization percentage of 0.008399999999999963\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14873 of 15000 requests have been made against our quota for a utilization percentage of 0.008466666666666622\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14872 of 15000 requests have been made against our quota for a utilization percentage of 0.008533333333333282\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14871 of 15000 requests have been made against our quota for a utilization percentage of 0.008600000000000052\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14870 of 15000 requests have been made against our quota for a utilization percentage of 0.008666666666666711\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14869 of 15000 requests have been made against our quota for a utilization percentage of 0.00873333333333337\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14868 of 15000 requests have been made against our quota for a utilization percentage of 0.00880000000000003\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14867 of 15000 requests have been made against our quota for a utilization percentage of 0.00886666666666669\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14866 of 15000 requests have been made against our quota for a utilization percentage of 0.008933333333333349\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14865 of 15000 requests have been made against our quota for a utilization percentage of 0.009000000000000008\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14864 of 15000 requests have been made against our quota for a utilization percentage of 0.009066666666666667\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14863 of 15000 requests have been made against our quota for a utilization percentage of 0.009133333333333327\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14862 of 15000 requests have been made against our quota for a utilization percentage of 0.009199999999999986\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14861 of 15000 requests have been made against our quota for a utilization percentage of 0.009266666666666645\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14860 of 15000 requests have been made against our quota for a utilization percentage of 0.009333333333333305\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14859 of 15000 requests have been made against our quota for a utilization percentage of 0.009399999999999964\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14858 of 15000 requests have been made against our quota for a utilization percentage of 0.009466666666666623\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14857 of 15000 requests have been made against our quota for a utilization percentage of 0.009533333333333283\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14856 of 15000 requests have been made against our quota for a utilization percentage of 0.009600000000000053\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14855 of 15000 requests have been made against our quota for a utilization percentage of 0.009666666666666712\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14854 of 15000 requests have been made against our quota for a utilization percentage of 0.009733333333333372\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14853 of 15000 requests have been made against our quota for a utilization percentage of 0.009800000000000031\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14852 of 15000 requests have been made against our quota for a utilization percentage of 0.00986666666666669\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14851 of 15000 requests have been made against our quota for a utilization percentage of 0.00993333333333335\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14850 of 15000 requests have been made against our quota for a utilization percentage of 0.010000000000000009\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14849 of 15000 requests have been made against our quota for a utilization percentage of 0.010066666666666668\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14848 of 15000 requests have been made against our quota for a utilization percentage of 0.010133333333333328\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14847 of 15000 requests have been made against our quota for a utilization percentage of 0.010199999999999987\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14846 of 15000 requests have been made against our quota for a utilization percentage of 0.010266666666666646\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14845 of 15000 requests have been made against our quota for a utilization percentage of 0.010333333333333306\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14844 of 15000 requests have been made against our quota for a utilization percentage of 0.010399999999999965\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14843 of 15000 requests have been made against our quota for a utilization percentage of 0.010466666666666624\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14842 of 15000 requests have been made against our quota for a utilization percentage of 0.010533333333333283\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14841 of 15000 requests have been made against our quota for a utilization percentage of 0.010600000000000054\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14840 of 15000 requests have been made against our quota for a utilization percentage of 0.010666666666666713\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14839 of 15000 requests have been made against our quota for a utilization percentage of 0.010733333333333372\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14838 of 15000 requests have been made against our quota for a utilization percentage of 0.010800000000000032\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14837 of 15000 requests have been made against our quota for a utilization percentage of 0.010866666666666691\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14836 of 15000 requests have been made against our quota for a utilization percentage of 0.01093333333333335\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14835 of 15000 requests have been made against our quota for a utilization percentage of 0.01100000000000001\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14834 of 15000 requests have been made against our quota for a utilization percentage of 0.011066666666666669\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14833 of 15000 requests have been made against our quota for a utilization percentage of 0.011133333333333328\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14832 of 15000 requests have been made against our quota for a utilization percentage of 0.011199999999999988\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14831 of 15000 requests have been made against our quota for a utilization percentage of 0.011266666666666647\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14830 of 15000 requests have been made against our quota for a utilization percentage of 0.011333333333333306\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14829 of 15000 requests have been made against our quota for a utilization percentage of 0.011399999999999966\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14828 of 15000 requests have been made against our quota for a utilization percentage of 0.011466666666666625\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14827 of 15000 requests have been made against our quota for a utilization percentage of 0.011533333333333284\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14826 of 15000 requests have been made against our quota for a utilization percentage of 0.011600000000000055\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14825 of 15000 requests have been made against our quota for a utilization percentage of 0.011666666666666714\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14824 of 15000 requests have been made against our quota for a utilization percentage of 0.011733333333333373\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14823 of 15000 requests have been made against our quota for a utilization percentage of 0.011800000000000033\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14822 of 15000 requests have been made against our quota for a utilization percentage of 0.011866666666666692\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14821 of 15000 requests have been made against our quota for a utilization percentage of 0.011933333333333351\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14820 of 15000 requests have been made against our quota for a utilization percentage of 0.01200000000000001\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14819 of 15000 requests have been made against our quota for a utilization percentage of 0.01206666666666667\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14818 of 15000 requests have been made against our quota for a utilization percentage of 0.01213333333333333\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14817 of 15000 requests have been made against our quota for a utilization percentage of 0.012199999999999989\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14816 of 15000 requests have been made against our quota for a utilization percentage of 0.012266666666666648\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14815 of 15000 requests have been made against our quota for a utilization percentage of 0.012333333333333307\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14814 of 15000 requests have been made against our quota for a utilization percentage of 0.012399999999999967\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14813 of 15000 requests have been made against our quota for a utilization percentage of 0.012466666666666626\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14812 of 15000 requests have been made against our quota for a utilization percentage of 0.012533333333333285\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14811 of 15000 requests have been made against our quota for a utilization percentage of 0.012599999999999945\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14810 of 15000 requests have been made against our quota for a utilization percentage of 0.012666666666666715\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14809 of 15000 requests have been made against our quota for a utilization percentage of 0.012733333333333374\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14808 of 15000 requests have been made against our quota for a utilization percentage of 0.012800000000000034\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14807 of 15000 requests have been made against our quota for a utilization percentage of 0.012866666666666693\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14806 of 15000 requests have been made against our quota for a utilization percentage of 0.012933333333333352\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14805 of 15000 requests have been made against our quota for a utilization percentage of 0.013000000000000012\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14804 of 15000 requests have been made against our quota for a utilization percentage of 0.013066666666666671\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14803 of 15000 requests have been made against our quota for a utilization percentage of 0.01313333333333333\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14802 of 15000 requests have been made against our quota for a utilization percentage of 0.01319999999999999\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14801 of 15000 requests have been made against our quota for a utilization percentage of 0.013266666666666649\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14800 of 15000 requests have been made against our quota for a utilization percentage of 0.013333333333333308\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14799 of 15000 requests have been made against our quota for a utilization percentage of 0.013399999999999967\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14798 of 15000 requests have been made against our quota for a utilization percentage of 0.013466666666666627\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14797 of 15000 requests have been made against our quota for a utilization percentage of 0.013533333333333286\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14796 of 15000 requests have been made against our quota for a utilization percentage of 0.013599999999999945\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14795 of 15000 requests have been made against our quota for a utilization percentage of 0.013666666666666716\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14794 of 15000 requests have been made against our quota for a utilization percentage of 0.013733333333333375\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14793 of 15000 requests have been made against our quota for a utilization percentage of 0.013800000000000034\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14792 of 15000 requests have been made against our quota for a utilization percentage of 0.013866666666666694\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14791 of 15000 requests have been made against our quota for a utilization percentage of 0.013933333333333353\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14790 of 15000 requests have been made against our quota for a utilization percentage of 0.014000000000000012\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14789 of 15000 requests have been made against our quota for a utilization percentage of 0.014066666666666672\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14788 of 15000 requests have been made against our quota for a utilization percentage of 0.014133333333333331\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14787 of 15000 requests have been made against our quota for a utilization percentage of 0.01419999999999999\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14786 of 15000 requests have been made against our quota for a utilization percentage of 0.01426666666666665\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14785 of 15000 requests have been made against our quota for a utilization percentage of 0.014333333333333309\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14784 of 15000 requests have been made against our quota for a utilization percentage of 0.014399999999999968\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14783 of 15000 requests have been made against our quota for a utilization percentage of 0.014466666666666628\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14782 of 15000 requests have been made against our quota for a utilization percentage of 0.014533333333333287\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14781 of 15000 requests have been made against our quota for a utilization percentage of 0.014599999999999946\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14780 of 15000 requests have been made against our quota for a utilization percentage of 0.014666666666666717\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14779 of 15000 requests have been made against our quota for a utilization percentage of 0.014733333333333376\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14778 of 15000 requests have been made against our quota for a utilization percentage of 0.014800000000000035\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14777 of 15000 requests have been made against our quota for a utilization percentage of 0.014866666666666695\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14776 of 15000 requests have been made against our quota for a utilization percentage of 0.014933333333333354\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14775 of 15000 requests have been made against our quota for a utilization percentage of 0.015000000000000013\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14774 of 15000 requests have been made against our quota for a utilization percentage of 0.015066666666666673\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14773 of 15000 requests have been made against our quota for a utilization percentage of 0.015133333333333332\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14772 of 15000 requests have been made against our quota for a utilization percentage of 0.015199999999999991\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14771 of 15000 requests have been made against our quota for a utilization percentage of 0.01526666666666665\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14770 of 15000 requests have been made against our quota for a utilization percentage of 0.01533333333333331\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14769 of 15000 requests have been made against our quota for a utilization percentage of 0.01539999999999997\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14768 of 15000 requests have been made against our quota for a utilization percentage of 0.015466666666666629\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14767 of 15000 requests have been made against our quota for a utilization percentage of 0.015533333333333288\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14766 of 15000 requests have been made against our quota for a utilization percentage of 0.015599999999999947\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14765 of 15000 requests have been made against our quota for a utilization percentage of 0.015666666666666718\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14764 of 15000 requests have been made against our quota for a utilization percentage of 0.015733333333333377\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14763 of 15000 requests have been made against our quota for a utilization percentage of 0.015800000000000036\n",
      "INFO:root:Successful request to the exchange rate API endpoint.\n",
      "INFO:root:After this request, 14762 of 15000 requests have been made against our quota for a utilization percentage of 0.015866666666666696\n"
     ]
    }
   ],
   "source": [
    "#get the exchange rate for each donation from the Currency API using the get_currencies.py file\n",
    "\n",
    "if len(currencies_dates) > 0:\n",
    "    records = []\n",
    "    for c in currencies_dates.iterrows():\n",
    "        data = c[1]\n",
    "        local_currency = data[0]\n",
    "        date = data[1].strftime('%Y%m%d')\n",
    "\n",
    "        exchange_rate = get_currencies(\n",
    "                                       BASE_CURRENCY\n",
    "                                       ,local_currency\n",
    "                                       ,date\n",
    "                                       ,API_KEY\n",
    "                                       ,API_URL\n",
    "                                       )\n",
    "        records.append(exchange_rate)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "4e46b164",
   "metadata": {},
   "outputs": [],
   "source": [
    "#save results\n",
    "data = [rows.__dict__ for days in records for rows in days]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "b618e906",
   "metadata": {},
   "outputs": [],
   "source": [
    "#format results as a dataframe\n",
    "if len(data) > 0:\n",
    "    all_exchange_rates = pd.DataFrame(data)\n",
    "    all_exchange_rates['exchange_rate_date'] = all_exchange_rates.apply(lambda x: parse(x['exchange_rate_date']).date(), axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "b0e2876b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1297 records were successfuly converted.\n"
     ]
    }
   ],
   "source": [
    "#save results as a CSV\n",
    "if len(all_exchange_rates) > 0 and len(sf_donations_df) > 0:\n",
    "    conversion = sf_donations_df.merge(all_exchange_rates[['local_currency', 'exchange_rate_date', 'exchange_rate']]\n",
    "                                       ,how = 'left'\n",
    "                                       ,on = ['local_currency', 'exchange_rate_date']\n",
    "                                       ,indicator = True)\n",
    "    \n",
    "    conversion['base_currency_amount'] = conversion.apply(lambda x: round(x['local_currency_amount']/x['exchange_rate'], 2), axis = 1)\n",
    "    \n",
    "    print('{} records were successfuly converted.'.format(len(conversion[conversion['_merge'] == 'both'])))\n",
    "    \n",
    "    conversion[conversion['_merge'] == 'both'].to_csv('currency_conversion_{}.csv'.format(file_date))\n",
    "    \n",
    "    #conversion[conversion['_merge'] != 'both'].to_csv('no_currency_conversion_{}.csv'.format(file_date))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "019d8bf9",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}