StockFetcher Forums · General Discussion · set function help<< >>Post Follow-up
jdemuth17
2 posts
msg #144197
Ignore jdemuth17
modified
7/25/2018 1:34:43 PM

I'm trying to track change % column to export to excel

Any time I use close of different days in a set function is returning 0

Ex.
Set{change,close(1)-close(2)}
Set{change1,change/close(2)}
Set{change%,change1*100}

Add column change%

Am I missing something or is it not supported

Thanks

four
5,087 posts
msg #144201
Ignore four
modified
7/25/2018 2:50:51 PM

Notice how StockFetcher handles previous days.

Try...

Fetcher[
Set{ch, close 0 days ago - close 1 day ago )}
Set{ch1, ch / close 1 day ago}
Set{ch_per, ch1 * 100}

Add column ch_per
]



four
5,087 posts
msg #144202
Ignore four
7/25/2018 2:51:42 PM

Link to guide
https://www3.stockfetcher.com/download/sfuserguide2_0.pdf

jdemuth17
2 posts
msg #144204
Ignore jdemuth17
7/25/2018 5:59:07 PM

Thank you

four
5,087 posts
msg #144206
Ignore four
7/25/2018 10:26:46 PM

welcome

StockFetcher Forums · General Discussion · set function help<< >>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 2022 - 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


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.