Google Finance Streamlit Dashboard

This project is a simple Streamlit app that visualizes stock data pulled from a Google Sheet that updates daily using the GOOGLEFINANCE formula.

Features

• Uses Google Sheets as a data source
• Sheet auto-updates daily with formula
  =GOOGLEFINANCE("AAPL", "all", TODAY()-14, TODAY(), "DAILY")
• Connects to the sheet via Google Sheets API
• Deployed on Streamlit Cloud
• Includes a manual Refresh button to force update

if refresh:
    download_data.clear()
    transform_data.clear()
    st.cache_resource.clear()
    st.rerun()

Live Demo

View the live dashboard below:

Setup

1. Clone the repository

2. Create a secrets.toml file or use st.secrets to store your Google service account credentials

3. Install dependencies

   pip install -r requirements.txt
   

4. Run the app

   streamlit run app.py
   

Deployment

Currently deployed on Streamlit Cloud.

Next Steps

• Modularize code (separate data download, transformation, and UI)
• Explore other deployment options such as VPS, Google Cloud VM, or Docker
• Add scheduled refresh using Streamlit Community Cloud or external cronjob
• Add more stock symbols and make selection dynamic