{"id":1173,"date":"2016-04-14T09:01:38","date_gmt":"2016-04-14T13:01:38","guid":{"rendered":"http:\/\/www.xavignu.com\/?p=1173"},"modified":"2016-04-15T12:39:54","modified_gmt":"2016-04-15T16:39:54","slug":"create-csv-file-ordered-with-highest-yield-dividend-paying-stock","status":"publish","type":"post","link":"https:\/\/www.xavignu.com\/?p=1173","title":{"rendered":"Create csv file ordered with highest yield dividend paying stock"},"content":{"rendered":"

For this script to work Yahoo Finance<\/a> is needed. It can be easily installed with pip. Stock tickers are taken from a file called tickers.txt.<\/p>\n

[python]
\n#!\/usr\/bin\/env python<\/p>\n

import time
\nfrom yahoo_finance import Share<\/p>\n

dict = {}
\nf = open(“tickers.txt”, “r”)
\nfor ticker in f.readlines():
\n dividend = Share(ticker).get_dividend_yield()
\n if dividend is not None:
\n print ticker.rstrip()+”: “+dividend
\n if float(dividend) > 0:
\n dict[float(dividend)] = ticker.rstrip()
\nf.close()<\/p>\n

filename = “dividends-“+time.strftime(“%Y%m%d”)+”.csv”
\nf = open(filename, “a”)
\nf.write(“Ticker, Dividend Yield, Dividend Share, Stock Price\\n”)
\nprint “Ticker; Dividend Yield; Dividend Share; Stock Price\\n”
\nfor k in reversed(sorted(dict.keys())):
\n escribir = dict[k]+”,”+str(k)+”,”+str(float(Share(dict[k]).get_dividend_share()))+”,”+str(float(Share(dict[k]).get_price()))+”\\n”
\n print dict[k]+”;”+str(k)+”;”+Share(dict[k]).get_dividend_share()+”;”+Share(dict[k]).get_price()
\n f.write(escribir)
\nf.close()
\n[\/python]<\/p>\n

When done it creates a csv (named dividends-YYYYMMDD.csv) file ordered by highest dividend yield paying stocks.
\n[shell]
\n00:55:40 [me@server Finance]$ head -5 dividends-20160414.csv
\nTicker, Dividend Yield, Dividend Share, Stock Price
\nGLBL,44.0,1.1,2.64
\nCLM,29.7,4.42,15.624
\nXRDC,22.99,0.6,2.65
\nCRF,22.1,3.98,16.75
\n00:55:49 [me@server Finance]$
\n[\/shell]<\/p>\n","protected":false},"excerpt":{"rendered":"

For this script to work Yahoo Finance is needed. It can be easily installed with pip. Stock tickers are taken from a file called tickers.txt. [python] #!\/usr\/bin\/env python import time from yahoo_finance import Share dict = {} f = open(“tickers.txt”, “r”) for ticker in f.readlines(): dividend = Share(ticker).get_dividend_yield() if dividend is not None: print ticker.rstrip()+”: […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[62],"tags":[44,22,6,67,70],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/pTQgt-iV","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/posts\/1173"}],"collection":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1173"}],"version-history":[{"count":9,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/posts\/1173\/revisions"}],"predecessor-version":[{"id":1184,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/posts\/1173\/revisions\/1184"}],"wp:attachment":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}