===============================================
REQUIREMENTS - Please ensure before running:
===============================================
1. PYTHON: Install Python 3.x from https://www.python.org/downloads/
   - Check "Add Python to PATH" during installation
   
2. PACKAGES: Run in terminal:
   pip install requests python-dotenv

3. API KEY: Get an Alpha Vantage API key from https://www.alphavantage.co/support/#api-key
   - Free tier available (5 calls/minute)
   - A template file, env-template.txt, is provided with the course materials.
     The setup step below will turn it into your .env file for you.
===============================================

SETUP STEP (do this before anything else)
Check whether a .env file exists in the root folder.
If it does not, create one by copying env-template.txt to a file named .env in the root folder.
Then ask the user for their Alpha Vantage API key, and replace your_key_here in .env with the key they provide.
Do not start the tasks below until .env contains a real API key.

Use the xlsx skill at https://github.com/anthropics/skills/tree/main/skills/xlsx

TASK 1
Create an Excel spreadsheet for an Investment Bank which analyses Value at Risk of a portfolio which has 5 stocks which you choose at random. 

It should be high quality and professional, with proper formatting, charts, and analysis. The styling should be consistent with Investment Bank grade spreadsheets, with a premium aesthetic. Ensure that the layout is clear, and metrics are labelled.

Analyse 02-AlphaVantage.txt to understand the Alpha Vantage API, 03-FetchData.py to understand how to use it, and 04-MSFTdata.json to understand a sample data. The API key is in the .env file. 

TASK 2
Analyse the file used to create the Excel spreadsheet and rigorously check for misaligned references to cells, and correct any errors

Rerun with the correct references and verify that the spreadsheet is correct