Amateur Trader's Diary - Tuesday Updates & Automating with Python

After updating today's closing price results for the stocks I am watching this week I realized that all the manual look up and entry of the prices could be automated with python. I haven't written a python code in a while and had to watch some tutorials and it turned out to be super easy to do. The screenshot image of the python code above is the first step in accomplishing this task. So far, the code takes a list of stocks and start date, then fetches the price data for each stock in the list from Yahoo Finance.

What I want the code to do is to create and update the watched stocks spreadsheet everyday, evaluate the prices and mark the cells either red or green. It seems simple and saves time. Getting the data part is done. Now I need to figure out how to save all the data on a spreadsheet.

One thing I haven't been paying attention but the code helped realize that, I have not been paying attention to the trade volume. Luckily the code is returning that data too. Not sure if I will need, but good to know it is easily available. I will continue learning more about using python for stocks and utilizing it to automate this process, and maybe more.

Tuesday closing prices look good. StockDweebs picks performed well again. Most of my picks stayed green. Those that were in red yesterday turned green too. I will probably skip updates for Wednesday and Thursday. Instead will post the results for the entire week this weekend.

Stocks on the watchlist: $WFC, $SAVE, $CCL, $TWTR, $DVAX, $SQ, $SDC, $FLR, $COTY, $GE, $ACB, $CBRL, $AVGO, $CMD, $EVRI, $GPS, $MTN, $RH, $PENN, $TRIP, $YELP, $HAL, $APT

Read the previous posts:

1. Amateur Trader's Diary - Reentry to the Stock Market

2. Amateur Trader's Diary - Getting Ready for the Trading Week

3. Amateur Trader's Diary - Monday Closing Stock Prices Updated

4. Amateur Trader's Diary - Story of Cobalt International Energy

Posted Using LeoFinance