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
Coding becomes easier if you do it yourself. Great post and source of motivation of others who love to utilize their coding skill. Gitplait platform is looking for people like you.
Your post has been curated with @gitplait community account because this is the kind of publications we like to see in our community.
Join our Community on Hive and Chat with us on Discord.
[Gitplait-Team]
Thank you.
I have picked your post for my daily hive voting initiative, Keep it up and Hive On!!
Thank You.
@geekgirl, Good luck with your Automation Process. Hope that going forward this step will make things easy for you when it comes to the Stock Price Analysis.
Have a great time ahead and stay blessed.
Thank you.
Welcome.
I believe that you are not an amateur trader @geekgirl :P
Best regards to your daily tasks and trades. Peace, Abundance, and Liberty unto you always :)
Thank You @cryptopie!
I wish I know how to write code!
Someday I should invest some time and learn a little bit.
cheers!
I don’t know a lot. I learned from python devs here. Python is easy to learn and really good for simple automation work. In the past it helped me with curating.
Really nice! What is your background? Did you study any engineering degree?
no, international affairs.
Cool! Really good that you managed to do that then. I will take a look on this next holidays.