Several different foreign currency symbols are identified for the purpose of retrieving exchange rates. A list of these symbols is used in a Python script to retrieve exchange rate data from yahoo finance for a given time period. This script can be run anytime and for any time period by specifying a begin date and end date. After the data is retrieved and inserted into a data frame, several adjustments are made to the data frame to facilitate future data analysis.
The modified data frame includes only three columns including the date, adjusted closing price, and the foreign exchange symbol. Lastly, we rotate the table so that foreign exchange symbols became the new column headings and the exchange rates are at the intersection of the date and the symbol. This will facilitate deeper Python analysis that is illustrated in the next video.