I just revamped my watchlist, moved it from Google Doc to Spreadsheet, and incorporated data from different sources, to automatically fetch news and stock information, like float, sector and volume.
Here's a preview (in addition I have colums were I write my plans):
And here are the formulas (the ticker symbol is used as the reference, B column):
SECTOR: =index(importxml("https://eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols="&B11&"";"//div[@class='sub-heading']//span[@class='right']");1)
SEC-FILINGS LINK TICKER: =HYPERLINK("https://www.sec.gov/cgi-bin/browse-edgar?Find=Search&owner=exclude&action=getcompany&CIK="&B11;"sec")
FLOAT: =importData(concatenate("http://finance.yahoo.com/d/quotes.csv?s=";$B11;"&f=f6"))
PRICE: =GOOGLEFINANCE(B11;"price")
VOLUME: =GOOGLEFINANCE(B11;"volume")
AVG VOLUME: =GOOGLEFINANCE(B11;"volumeavg")
FINVIZ LINK TICKER: =HYPERLINK("https://finviz.com/quote.ashx?t="&B11;"FinViz")
LATEST NEWS STORY URL (YAHOO): =IMPORTFEED("http://finance.yahoo.com/rss/headline?s="&B11;"items url";FALSE;1)
LATEST NEWS STORY SUMMARY (YAHOO): =IMPORTFEED("http://finance.yahoo.com/rss/headline?s="&B11;"items summary";FALSE;1)

Nice to see somebody using spreadsheets for more than just making cells to type into
Awesome!
Join now or log in to leave a comment