StockFetcher Forums · Public Filter List · how to add a column showing a calculated value<< >>Post Follow-up
smartguy
47 posts
msg #99743
Ignore smartguy
modified
3/17/2011 5:04:29 PM

I want to add a column that shows on my chart scan. I want to find the value , then show that value as a column. Can you help me with the actual code I need to add to my scan. Specifically, close today is 5% or more below the close of 2 days ago, then I want to be able to add a column on the chart that I can click to sort this value i.e sort the stocks with the highest % drop. Thanks in advance for your help.

Kevin_in_GA
4,599 posts
msg #99747
Ignore Kevin_in_GA
3/17/2011 8:00:44 PM

Fetcher[

close is above 0.50
volume is above 50000

close is greater than 5% below close 2 days ago

add column roc(2,1)
sort on column 5 ascending

]



Use the "add column" command, then "sort on column X ascending/descending"

Note that the ROC(2,1) function returns the percentage change in closing values between today and 2 days ago.

smartguy
47 posts
msg #99748
Ignore smartguy
3/17/2011 9:02:01 PM

Kevin_in_G - thank you for your kindness. Much appreciated.

StockFetcher Forums · Public Filter List · how to add a column showing a calculated value<< >>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.