Notes 6/20/23

 Notes 6/20/23

Great work from the UCONN team this week.

Were able to successfully extract prices of TSLA stock from yahoo finance using the yfinance python module and store that data into a datastore table(kind).

https://uconn-sa.blogspot.com/p/stock-prices.html

Stock Prices   Creation & Upload: import yfinance as yf import csv from google.cloud import datastore, storage from datetime import datetime tsla = yf.Ti... uconn-sa.blogspot.com



To build on this we need to:

1. Pull daily price instead of historical prices
2. Keep a table of stocks we want to pull prices for e.g. TSLA, MSFT, etc
3. Create a scheduled job that runs every day that pulls prices

https://cloud.google.com/scheduler

Cloud Scheduler | Google Cloud Fully managed cron service for scheduling virtually any job, including batch, big data jobs, and cloud infrastructure operations, with automated retries. cloud.google.com



The UCONN team also developed code to pull news out of Yahoo finance

https://uconn-sa.blogspot.com/p/news.html

To build on this code we need to:

1. Pull story or stories for that day for that symbol
2. Loop thru selected stocks to monitor
3. Store the story with headline in datastore
4. using Google sentiment record in datastore score and magnitude of headline and body of store
5. schedule job to run daily

https://uconn-sa.blogspot.com/p/sentiment.html

Great progress made this week.

Each team please report weekly progress before Friday's meeting.

Thanks

Sentiment   from google.cloud import language from google.cloud import language_v1 import six import pandas as pd data = pd.read_csv("all-data.csv", e... uconn-sa.blogspot.com



News   Body.py: import requests import yfinance as yf import csv from bs4 import BeautifulSoup tick = yf.Ticker("TSLA") news = tick.news news_arr... uconn-sa.blogspot.com

