jjmcguire 22 posts msg #157909 - Ignore jjmcguire |
10/21/2021 7:08:35 PM
Hello, how do I select only the stocks I rated with a Buy this week? The code below returns all the stocks I have rated as a Buy, but over time this list gets too big. I just want the ones I have recently rated.
Thanks,
Jason
|
redversa721 157 posts msg #157911 - Ignore redversa721 |
10/22/2021 1:22:53 PM
I have not used the rating fucntion but if it lile a watchlist, can you move all the one prior to this week to a new watchlist and only have ones that you selected this week in the myrating one?
|
redversa721 157 posts msg #157912 - Ignore redversa721 |
10/22/2021 1:31:42 PM
So just tested the function.I can see two options
1. option 1 , have myrating and myrating_old
whatever you add this week goes to myrating. end of week, download to csv and upload to myrating_old [if you have a lot of stocks. Then you delete all the remaining stocks in myrating, so it can be used from scratch for next week
2. Option 2- have myrating and each week create a new list of backups, so myratingw1, myraitngw2...
Once you have populated myratig for week, just duplicate it and name it what you want. then delete all stocks in myrating.
Maybe there are other options. I believe you can also run a filter on myrating [basically pull all stocks and auto populate myrating_old.That option i believe should work but I have not tried.
|