StockFetcher Forums · Filter Exchange · % difference between columns in results<< >>Post Follow-up
karennma
8,057 posts
msg #51617
Ignore karennma
5/15/2007 6:07:56 PM

After you get your filter results, does anyone know who to say:
(for example)
"and add column % difference between column 1 and column 4"

So, I'm adding a column that gives me the % difference between the 2 columns in my results.

THANKS.


bielyplafon
42 posts
msg #51630
Ignore bielyplafon
5/16/2007 2:58:02 AM

karennma
- Ignore karennma 5/15/2007 3:07:56 PM

After you get your filter results, does anyone know who to say:
(for example)
"and add column % difference between column 1 and column 4"

So, I'm adding a column that gives me the % difference between the 2 columns in my results.

THANKS.
------------

You need to define it in the filter and add column.
E.g.
column1 = close
column4 = close 1 day ago
set{ccc1, column1 / column4}
set{ccc2, ccc1 - 1}
set{PercDiff, ccc2 * 100}
add column PercDiff


karennma
8,057 posts
msg #51638
Ignore karennma
5/16/2007 3:34:24 PM

Biely:
OMG!!
Thanks!
:>)


karennma
8,057 posts
msg #51639
Ignore karennma
5/16/2007 3:41:36 PM

Hi Biely:
Sorry to bother you again ..
Can you tell me what I did wrong?
Thanks.
k.

column2 = close
column6 = 52 week high
set{ccc1, column2 / column6}
set{ccc2, ccc1 - 1}
set{PercDiff, ccc2 * 100}
add column PercDiff


conyeuchua
83 posts
msg #51649
Ignore conyeuchua
5/16/2007 10:51:57 PM

set{column2,close}
set{column6,52 week high}
set{ccc1, column2 / column6}
set{ccc2, ccc1 - 1}
set{PercDiff, ccc2 * 100}
add column PercDiff


karennma
8,057 posts
msg #51651
Ignore karennma
5/17/2007 8:26:11 AM

Cony:
Sweet!
Thank you, thank, you, thank you!
May all your profits be swift and HUGE!
$$$$$$$$
:>)


StockFetcher Forums · Filter Exchange · % difference between columns in results<< >>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.