Rauni
I found the code I was looking at, and it uses matplotlib to create the 3D graph. I've attached the code and a png of the resulting graph to this email. My question: what would the sponsor want us to plot? Because the linear regression plot I had shown them last Friday was plotting average sentiment vs the stock price for the quarter, which didn't look too great. One change I made that greatly improved this graph was instead graphing the average sentiment vs the change in stock price between quarters, which I've also attached.
Now my question is what are the sets I should be plotting on the multiple regression plot? We have the various categories, which we get the sentiment average from, but what would plotting that look like? We have 4 categories: Macro, Sector Trend, Regulation and Financial Metric. Each has its own sentiment score per quarter. So possible points of data are category sentiment, average quarter sentiment, stock price, and change of stock price.
Over 8 quarters the 3 variables are:
Stock change in px (in local currency), eg. WSP
Sentiment of firms transcripts (WSP earnings reports)
Sentiment of sector (engineering and design for WSP) by averaging sentiment of firms in the sector
Here's what I'm looking to complete for the week:
1. Run sentiment on streamlined keywords list
2. Make multiple regression plot using the guidelines discussed on Friday
3. Modify how code takes input and output, label quarters with year (I.E instead of Q1, Q2, etc.. It's Q3 2021, Q4 2021, Q1 2022, etc.)
Charlton
Upload Excel sentiment results files to DataStore
data management
Continue data documentation
Data table for terms
No comments:
Post a Comment