Sorting Through the News
I’ve used Yahoo Finance for over 15 years.? I think it is the best single free news source for companies on the web.? If you know a better source, please mention it in the comments.
But there is a lot of low value data in their news feeds, so I created a utility to eliminate the bad stuff.? The link to it is in step 11 below.? I’m sharing one of my tools with you.? I hope it works well for you if you try it.
Procedure
- Using your browser, go to Yahoo Finance, and choose one of your portfolios.
- Hit the ?End? key to go to the bottom of the screen, and hit ?Page up.?? You will see a little link on the left labeled ?more News? with a caret pointing downward.? If you to go further back in time, click the link.? If you want still more news, just keep repeating ?End, Page Up, Click? until you cover the whole time you want news for.
- Hit Ctrl-A, Ctrl-C to copy the whole browser window
- Ctrl-V to paste into Excel
- Ctrl-F, search for ?day and time?
- Using Shift, press Page Down to highlight all of the stories, Ctrl-C to copy
- Paste into a new sheet
- Widen Column B a lot, such that the only columns you see are A through D
- Click “Merge and Center” to demerge all cells
- Click on the Sort A-to-Z button
- Open the news screener, hit Ctrl-C to copy
- Flip back to the sheet you had open in step 10, and hit Ctrl-V to paste in Spreadsheet at cell D1
- Make sure to copy down new paste to cover all of your rows, or delete rows for which there is no news.
- Sort on the rightmost column
- Delete all the rows labeled “Here” in the rightmost column
- Delete all of the columns from ?C? to the right.
- Enjoy
- Optional ? With your cursor in cell A1, click the button to create a pivot-table.? Take defaults, hit OK.
- Click and Drag ?day and time? into the row labels, and values
- Then click down arrow next to Row Labels on the pivot table, and choose ?More Sort Options?
- Click Descending (Z to A) and choose ?Count of day and time.?? Click OK, and you are done.
- Really enjoy.
After step 17, you would have something that looks like this:
After step 22, you would have something that looked like this:
Row Labels | Count of day and time |
WFC |
153 |
CVX |
32 |
INTC |
22 |
XRX |
20 |
ORCL |
17 |
CSCO |
16 |
BP |
5 |
VOD |
4 |
AIZ |
3 |
TEL |
2 |
BRK-B |
2 |
L |
2 |
VLO |
1 |
TRV |
1 |
PSX |
1 |
ESV |
1 |
RGA |
1 |
Grand Total |
283 |
The purpose of creating the pivot table is to highlight stocks with a lot of news.? Stocks with lots of news, you typically know what happened.? I set my limit at 10 stories.? If there are more, I do a quick scan of the companies with a lot of articles and see if it is just one story written many times.? In this case, I deleted the stories from WFC and XRX — there was basically one story for each.? WFC earnings, and XRX’s CFO leaving to go to Apple.
That left me with only 110 articles to look at out of 467 at the start of this exercise.? As it was, I chose to read 10 of the articles.? It takes me 3 minutes to use the news screener (once you get used to it, it is fast), and it saves me tons of time, and helps me be more focused in what I read.
This is my way of wading through too many articles, eliminating robotic, and lower quality content.? Note: if you don’t agree with what I think is low value, you can change the headers in my spreadsheet in columns D through N.
I hope you enjoy this.
Full disclosure: long AIZ, BP, BRK-B, CSCO, CVX, ESV, INTC, L, ORCL, PSX, RGA, TEL, TRV, VLO, VOD, WFC, XRX