StockFetcher Forums · Filter Exchange · Dividend Yield% shows negative value<< >>Post Follow-up
kmadnani
17 posts
msg #152614
Ignore kmadnani
modified
6/12/2020 11:10:32 AM

Is there a way to change the negative Dividend Yield% value to N/A for negative values instead of not showing the stocks by using an ABS (Yield%) function? I would like to still see the stocks without dividends. The reason is on other screens this column with large Yield% values (negative) takes a lot of space.

Fetcher[show stocks where market cap is above 2000 and add column market cap

average volume(21) > 200000
close > 10
close >= close 1 day ago /*added per initial TOS post*/
not etf

add column dividend {div}
set{dividendyield, dividend / close}
set{yield%, dividendyield * 100}
add column yield%
]



kmadnani
17 posts
msg #152615
Ignore kmadnani
6/12/2020 11:39:31 AM

Ok Guess used the wrong code. This works better

Fetcher[show stocks where market cap is above 2000 and add column market cap

average volume(21) > 200000
close > 10
close >= close 1 day ago /*added per initial TOS post*/
not etf

and add column dividend {dividend}
and add column dividend yield {yield%}
and add column since dividend {since_div}
]



StockFetcher Forums · Filter Exchange · Dividend Yield% shows negative 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.