Skip to content

Forex usd/CHF exchange rate #129

@tino1948

Description

@tino1948

i have this code:

Import packages

import requests
import pandas as pd
import matplotlib.pyplot as plt
from datetime import datetime

Set the start and end date

start_date = '2023-01-01'
end_date = datetime.now().strftime("%Y-%m-%d")

Define the ticker list

tickers_input = input("Enter a list of tickers separated by commas: ")
tickers_list = tickers_input.split(",")
tickers_list = [ticker.strip() for ticker in tickers_list]

Create placeholder for data

data = pd.DataFrame()

Fetch the data

for ticker in tickers_list:
url = f"https://www.alphavantage.co/query?function=TIME_SERIES_DAILY_ADJUSTED&symbol={ticker}&apikey=YVPP8PYIMZMED6ZJ"
response = requests.get(url)
data_json = response.json()
if 'Error Message' in data_json:
print(f"Failed download: {ticker}")
else:
data[ticker] = pd.DataFrame.from_dict(data_json['Time Series (Daily)']).T['4. close']

Print first 5 rows of the data

print(data.head(5))

Convert data to numerical

data = data.apply(pd.to_numeric)

Plot all the close prices

data.plot(figsize=(80, 20))

Show the legend

plt.legend()

Define the label for the title of the figure

plt.title(ticker, fontsize=16)

Define the labels for x-axis and y-axis

plt.ylabel('Kurs', fontsize=14)
plt.xlabel('Date', fontsize=14)

Plot the grid lines

plt.grid(which="major", color='k', linestyle='-.', linewidth=0.5)
plt.show()

and i get this error:

Enter the start date (YYYY-MM-DD): 2023-01-01
Traceback (most recent call last):
File "/home/schaich/Dokumente/Python/USDCHF.py", line 31, in
rates = exchange_rate(start_date, end_date)
File "/home/schaich/Dokumente/Python/USDCHF.py", line 10, in exchange_rate
rates[date.strftime("%Y-%m-%d")] = cr.get_rate("USD", "CHF", date)
File "/home/schaich/.local/lib/python3.10/site-packages/forex_python/converter.py", line 79, in get_rate
raise RatesNotAvailableError("Currency Rates Source Not Ready")
forex_python.converter.RatesNotAvailableError: Currency Rates Source Not Ready

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions