Generate News Sentiment Scores in Excel
source link: https://www.tuicool.com/articles/VnqQnuy
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
with a single function
Jul 13 ·3min read
Scraped news article
I have gotten a request from one of my readers of Algorithmic Trading using Sentiment Analysis on News Articles to create a general tool which would allow you to get the sentiment scores from web-scraped news articles ( The Business Times ). I previously used it as a metric in algo trading but I figured it would be very useful to people from the portfolio management or risk side of Finance as well.
Idea
The idea was to make it easier for non-technical users to get a simple -1 to 1 score on Excel, based on various terms they are interested in across different days. I would imagine this being used in portfolio re-balancing or even as an automated form of media monitoring. The web-scraping and sentiment scoring was described in my previouspost.
9 simple steps to get set up
*Windows only*
1. LinkedIn message me with your email for the project folder
2. Open sentiment.py in project folder
3. Download and install Anaconda (Python)
https://www.anaconda.com/distribution/#download-section
4. Open command prompt and create conda environment
5. Enter the sentiment project directory and install packages
Assuming the folder is on your desktop
cd desktop/sentiment && pip install -r requirements.txt6. Reveal Developer tab in Excel
7. Enable settings
8. Open sentiment.xlsm and enable xlwings
9. Point xlwings to your conda environment and import python function
Specify the installation path to your Anaconda3
And.. we’re done!
Feel free to share any comments or ideas!
Recommend
-
116
** DEPRECATED ** This repo has been deprecated. Please visit Megatron-LM for our up to date Large-scale unsupervised pretraining and finetuning code. If you would...
-
46
GitHub is where people build software. More than 27 million people use GitHub to discover, fork, and contribute to over 80 million projects.
-
73
readme.md Booksoup Booksoup allows you to analyse and traverse your downloaded facebook data, including features such as s...
-
44
SSH Generator Simple tool to generate ssh keys. Every time when i used to create ssh keys it generally took at least 10mins as a beginner. It will not take more than 2mins to create your ssh keys using this.
-
14
ClosedXML.SimpleSheets A library to easily generate Excel sheets from data in F#. Built on top of ClosedXML Install dotnet add package ClosedXML.SimpleSheet...
-
10
A new update is live for the Windows Beta Channel Microsoft has recently released a new Office preview build for Windows users in the Beta Channel, with the company therefore bringing the produ...
-
6
Saurabh Gadgil November 1, 2022 6 minute read
-
3
Formula DogGenerate Excel formulas with AIFree OptionsTurn your spreadsheet problem into a formula in seconds.
-
8
Isaac Perez 45 minutes ago Generate Excel document in SAP CAP application 12 Views Last edit 43 minu...
-
1
News websites will use ChatGPT to generate articles
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK