create account

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

View this thread on: hive.blogpeakd.comecency.com
· @geekgirl ·
$12.69
Amateur Trader's Diary - Tuesday Updates & Automating with Python
![automate.png](https://images.hive.blog/DQmXvZAerU7Qgk7idkkmJs5NV5ujvD1AicL89LBSztd44gE/automate.png)

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. 

![tue.png](https://images.hive.blog/DQmWpALw73cCsCKan7yPkr2T9SU5iAHu74QRZhWEbX7nJod/tue.png)

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](https://leofinance.io/hive-167922/@geekgirl/amateur-trader-s-diary-reentry-to-the-stock-market)

[2. Amateur Trader's Diary - Getting Ready for the Trading Week](https://leofinance.io/hive-167922/@geekgirl/amateur-trader-s-diary-getting-ready-for-the-trading-week)

[3. Amateur Trader's Diary - Monday Closing Stock Prices Updated](https://leofinance.io/hive-167922/@geekgirl/amateur-trader-s-diary-monday-closing-stock-prices-updated)

[4. Amateur Trader's Diary - Story of Cobalt International Energy](https://leofinance.io/hive-167922/@geekgirl/amateur-trader-s-diary-story-of-cobalt-international-energy)

Posted Using [LeoFinance](https://leofinance.io/@geekgirl/amateur-trader-s-diary-tuesday-updates-and-automating-with-python)
πŸ‘  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 76 others
πŸ‘Ž  
properties (23)
authorgeekgirl
permlinkamateur-trader-s-diary-tuesday-updates-and-automating-with-python
categoryhive-167922
json_metadata{"tags":["market","stocks","python","coding","automating","leofinance"],"image":["https://images.hive.blog/DQmXvZAerU7Qgk7idkkmJs5NV5ujvD1AicL89LBSztd44gE/automate.png","https://images.hive.blog/DQmWpALw73cCsCKan7yPkr2T9SU5iAHu74QRZhWEbX7nJod/tue.png"],"links":["https://leofinance.io/hive-167922/@geekgirl/amateur-trader-s-diary-reentry-to-the-stock-market","https://leofinance.io/hive-167922/@geekgirl/amateur-trader-s-diary-getting-ready-for-the-trading-week","https://leofinance.io/hive-167922/@geekgirl/amateur-trader-s-diary-monday-closing-stock-prices-updated","https://leofinance.io/hive-167922/@geekgirl/amateur-trader-s-diary-story-of-cobalt-international-energy"],"app":"leofinance/0.1","format":"markdown","canonical_url":"https://leofinance.io/@geekgirl/amateur-trader-s-diary-tuesday-updates-and-automating-with-python"}
created2020-06-17 01:19:27
last_update2020-06-17 01:19:27
depth0
children14
last_payout2020-06-24 01:19:27
cashout_time1969-12-31 23:59:59
total_payout_value6.892 HBD
curator_payout_value5.795 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2,633
author_reputation1,586,488,611,824,452
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,010,097
net_rshares29,969,294,396,491
author_curate_reward""
vote details (141)
@chireerocks ·
$0.25
@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.
πŸ‘  
properties (23)
authorchireerocks
permlinkqc54b6
categoryhive-167922
json_metadata{"users":["geekgirl"],"app":"hiveblog/0.1"}
created2020-06-18 21:13:57
last_update2020-06-18 21:13:57
depth1
children2
last_payout2020-06-25 21:13:57
cashout_time1969-12-31 23:59:59
total_payout_value0.126 HBD
curator_payout_value0.126 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length208
author_reputation327,821,690,945,691
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,045,889
net_rshares910,773,486,184
author_curate_reward""
vote details (1)
@geekgirl ·
Thank you.
properties (22)
authorgeekgirl
permlinkre-chireerocks-qc57k9
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2020.05.5"}
created2020-06-18 22:24:12
last_update2020-06-18 22:24:12
depth2
children1
last_payout2020-06-25 22:24:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length10
author_reputation1,586,488,611,824,452
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,046,912
net_rshares0
@chireerocks ·
Welcome.
properties (22)
authorchireerocks
permlinkqc68kw
categoryhive-167922
json_metadata{"app":"hiveblog/0.1"}
created2020-06-19 11:43:48
last_update2020-06-19 11:43:48
depth3
children0
last_payout2020-06-26 11:43:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length8
author_reputation327,821,690,945,691
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,057,007
net_rshares0
@chitty ·
$0.25
I have picked your post for my daily hive voting initiative, Keep it up and Hive On!!
πŸ‘  
properties (23)
authorchitty
permlinkre-amateur-trader-s-diary-tuesday-updates-and-automating-with-python-20200619t000559
categoryhive-167922
json_metadata""
created2020-06-19 00:06:03
last_update2020-06-19 00:06:03
depth1
children1
last_payout2020-06-26 00:06:03
cashout_time1969-12-31 23:59:59
total_payout_value0.126 HBD
curator_payout_value0.126 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length86
author_reputation86,901,300,608,582
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,048,494
net_rshares914,418,148,923
author_curate_reward""
vote details (1)
@geekgirl ·
Thank You.
properties (22)
authorgeekgirl
permlinkre-chitty-qc5djj
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2020.05.5"}
created2020-06-19 00:33:21
last_update2020-06-19 00:33:21
depth2
children0
last_payout2020-06-26 00:33:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length10
author_reputation1,586,488,611,824,452
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,048,857
net_rshares0
@cryptopie ·
$0.25
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 :)
πŸ‘  
properties (23)
authorcryptopie
permlinkre-geekgirl-qc22il
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2020.05.5"}
created2020-06-17 05:42:21
last_update2020-06-17 05:42:21
depth1
children1
last_payout2020-06-24 05:42:21
cashout_time1969-12-31 23:59:59
total_payout_value0.126 HBD
curator_payout_value0.126 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length151
author_reputation829,274,168,394,582
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,012,546
net_rshares892,217,374,059
author_curate_reward""
vote details (1)
@geekgirl ·
Thank You @cryptopie!
properties (22)
authorgeekgirl
permlinkre-cryptopie-qc25d4
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2020.05.5"}
created2020-06-17 06:43:54
last_update2020-06-17 06:43:54
depth2
children0
last_payout2020-06-24 06:43:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length21
author_reputation1,586,488,611,824,452
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,013,434
net_rshares0
@gitplait-mod1 ·
$0.26
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](https://hive.blog/trending/hive-103590) and Chat with us on [Discord](https://discord.com/invite/CWCj3rw).

[Gitplait-Team]
πŸ‘  
properties (23)
authorgitplait-mod1
permlinkqc1uh0
categoryhive-167922
json_metadata{"users":["gitplait"],"links":["https://hive.blog/trending/hive-103590","https://discord.com/invite/CWCj3rw"],"app":"hiveblog/0.1"}
created2020-06-17 02:48:36
last_update2020-06-17 02:48:36
depth1
children1
last_payout2020-06-24 02:48:36
cashout_time1969-12-31 23:59:59
total_payout_value0.128 HBD
curator_payout_value0.128 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length468
author_reputation64,455,719,431
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,010,972
net_rshares909,631,844,281
author_curate_reward""
vote details (1)
@geekgirl ·
Thank you.
properties (22)
authorgeekgirl
permlinkre-gitplait-mod1-qc1vh3
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2020.05.5"}
created2020-06-17 03:10:15
last_update2020-06-17 03:10:15
depth2
children0
last_payout2020-06-24 03:10:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length10
author_reputation1,586,488,611,824,452
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,011,177
net_rshares0
@resiliencia ·
$0.24
I wish I know how to write code!
Someday I should invest some time and learn a little bit.

cheers!
πŸ‘  
properties (23)
authorresiliencia
permlinkre-geekgirl-qc39cc
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2020.05.5"}
created2020-06-17 21:07:24
last_update2020-06-17 21:07:24
depth1
children4
last_payout2020-06-24 21:07:24
cashout_time1969-12-31 23:59:59
total_payout_value0.121 HBD
curator_payout_value0.118 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length99
author_reputation438,637,492,561,057
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,026,443
net_rshares873,046,399,801
author_curate_reward""
vote details (1)
@geekgirl ·
$0.06
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.
πŸ‘  
πŸ‘Ž  
properties (23)
authorgeekgirl
permlinkre-resiliencia-qc39oc
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2020.05.5"}
created2020-06-17 21:14:36
last_update2020-06-17 21:14:36
depth2
children3
last_payout2020-06-24 21:14:36
cashout_time1969-12-31 23:59:59
total_payout_value0.044 HBD
curator_payout_value0.020 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length160
author_reputation1,586,488,611,824,452
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,026,534
net_rshares333,992,258,467
author_curate_reward""
vote details (2)
@resiliencia ·
Really nice! What is your background? Did you study any engineering degree?
properties (22)
authorresiliencia
permlinkre-geekgirl-qc39se
categoryhive-167922
json_metadata{"tags":["hive-167922"],"app":"peakd/2020.05.5"}
created2020-06-17 21:17:03
last_update2020-06-17 21:17:03
depth3
children2
last_payout2020-06-24 21:17:03
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length75
author_reputation438,637,492,561,057
root_title"Amateur Trader's Diary - Tuesday Updates & Automating with Python"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id98,026,572
net_rshares0