StockFetcher Forums · General Discussion · How to add 1-day performance column?<< >>Post Follow-up
stephenmcmahon83
8 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:

Fetcher[

/* Run Filter The Day After Buy */

/* Create Symbol List */

symlist(riot)

/* Enter yesterday's BUY price */
/* Assuming that you did not buy close price */
/* My example RIOT closed at 9 and I bought at 8.89 */

set{y_buy, 8.89}

/* Calculate difference = today's close - yesterday's buy price */

set{calc, close - y_buy}

/* Display Difference */

add column calc

]



stephenmcmahon83
8 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
7,341 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
7,341 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
7,341 posts
msg #143682
Ignore karennma
modified
5/29/2018 10:22:50 AM

Okay, guys!
Have FUN!
CLICK HERE

Edit:
Thanks Stockfetcher!

karennma
7,341 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
7 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


Fetcher[
/* Reference a specific date */
/*RSI(10) (value and plot) on July 20, 2018*/
set{r10,DATE(20180720,rsi(10))}
draw r10 on plot rsi(10)
add column r10
/*Close (value and plot)on July 20, 2018*/
set{var2,DATE(20180720,close)}
draw var2 on plot price
add column var2
and add column separator
/*Dollar value: change from July 20, 2018 to today*/
set{diff, close - DATE(20180720,close)}
add column diff
/*Dollar value: change from July 20, 2018 to September 10, 2018*/
set{diff2, DATE(20180910,close) - DATE(20180720,close)}
add column diff2
]



StockFetcher Forums · General Discussion · How to add 1-day performance column?<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2018 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus