Hi, Shrewd!        Login  
Shrewd'm.com 
A merry & shrewd investing community
Best Of Politics | Best Of | Favourites & Replies | All Boards | Post of the Week!
Search Politics
Shrewd'm.com Merry shrewd investors
Best Of Politics | Best Of | Favourites & Replies | All Boards | Post of the Week!
Search Politics


Halls of Shrewd'm / US Policy
Unthreaded | Threaded | Whole Thread (6) |
Author: FlyingCircus   😊 😞
Number: of 3959 
Subject: Re: Provide an Weekly Excel as Universe?
Date: 05/16/2024 10:25 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 2
So, @jcbbaa summarizing the responses: theoretically yes but practically no.

GTR1 is a screener, not a tracker. If you have all those weeks of all those picks, you could set up
a Google Sheet, then with a start date and end date for those seven...hundred...eighty (780) weeks you could build a formula in Sheets for that would basically get you the non-dividend adjusted prices for those time periods for those stocks.

=googlefinance(symbol, price, startdate, enddate)... exact syntax look up.

Don't forget capital gains tax, bid/ask spread, etc. in the estimated total return calc.

Good luck, FC
Post New | Post Reply | Report Post | Recommend It!
Print the post
Unthreaded | Threaded | Whole Thread (6) |


Announcements
US Policy FAQ
Contact Shrewd'm
Contact the developer of these message boards.

Best Of Politics | Best Of | Favourites & Replies | All Boards | Followed Shrewds