| StockFetcher Forums · General Discussion · How to add 1-day performance column? | << >>Post Follow-up |
| stephenmcmahon83 15 posts msg #143600 - Ignore stephenmcmahon83 |
5/18/2018 4:01:41 PM Hi, if I run a filter and look at the stocks generated from 6 months ago, the "perf%" column will show me the cumulative % return between 6 months ago and today. Can anyone please show me how I can add a column where I instead see the 1-day forward returns instead of the cumulative returns? Example, when looking at stocks generated by a filter on the close of May 1st, I would want to see what the returns would be if I bought the stock on May 1st and held until May 2nd. Any help here would be greatly appreciated. |
| four 5,087 posts msg #143601 - Ignore four modified |
5/18/2018 4:26:02 PM Perhaps... Does your broker offer this information? Perhaps... Use Excel? Otherwise... The manual effort is: |
| stephenmcmahon83 15 posts msg #143621 - Ignore stephenmcmahon83 |
5/21/2018 2:02:51 PM Hi four, Thank you for your attempt, but that isn't quite what I was looking for, with the manual entry of closing price. I like to sometimes look back in my filters to see what stocks were generated a few months ago, and would have like to have been able to see the 1-day, 2-day, 3-day performance from the day that the stock showed up from the filter, rather than the cumulative performance between 3 months ago and today. |
| four 5,087 posts msg #143623 - Ignore four modified |
5/21/2018 7:07:16 PM Put your list of stocks from your filter into a WATCHLIST and then OFFSET the list to the nth day after your filter triggered. . |
| karennma 8,057 posts msg #143658 - Ignore karennma |
5/25/2018 6:56:35 AM @ StephenMcMahon, Re: "Example, when looking at stocks generated by a filter on the close of May 1st, I would want to see what the returns would be if I bought the stock on May 1st and held until May 2nd." ================ Or bought April 9th and held until April 23rd ... whatever, etc. ... I've always wondered about that myself. You should send a message to SF. (Click the yellow square in the lower right hand corner of your screen.) |
| karennma 8,057 posts msg #143659 - Ignore karennma |
5/25/2018 6:57:21 AM Somehow, your specific dates would have to be embedded in the filter. |
| karennma 8,057 posts msg #143682 - Ignore karennma modified |
5/29/2018 10:22:50 AM Okay, guys! Have FUN! CLICK HERE Edit: Thanks Stockfetcher! |
| karennma 8,057 posts msg #143692 - Ignore karennma |
5/31/2018 7:33:00 AM Re: "CLICK HERE" ================= Anybody try these? I don't know how to make this sort do what I want. |
| nguyenak 10 posts msg #144650 - Ignore nguyenak |
9/12/2018 11:56:56 PM I need the same thing. How to add a column showing the next day's Closing Price? |
| four 5,087 posts msg #144660 - Ignore four modified |
9/13/2018 12:37:40 PM |
| StockFetcher Forums · General Discussion · How to add 1-day performance column? | << >>Post Follow-up |