stevehchis 
Gold User, Member, Platinum User, TeleChart

Registered User 




Gender: 

Sunday, March 07, 2010 
Saturday, October 14, 2017 11:25:09 PM 
166 [0.06% of all post / 0.06 posts per day] 

is there a way to compare the difference bettween the average volume (AvgV234.78) to the current volume ...in other words if the average volume (AvgV234.78) is 500k and the current volume is 600K
im looking for a column that will give me the difference ....so in this example the answer would be 100K
what would that formula be ? thank you

ok no clear so starting over
is there a formula that gives you the difference between yesterdays close minus the cash dividend..the difference between that and the current price in pennies ....
example yesterdays close is 5.50 the dividend is 50 cents ...so i want in this case the difference between 5.00 and the current price
i hope thats clear now...thank you

is there a formula that can give you the difference between the current price and the cash dividend in pennies...thank you

hi
can i get a formula that gives me the price difference between the sma 8 and sma 20
that i can adjust...thank you

i was wondering does the new xbars ago tool working or should i say work on intraday time frames
and i would think as long as it shows available on a formula it would work ....i would think ?
i tried it with this formula (below) on a 5min time frame and set it for > 38.2 130periods ago and scanned just one stock DNOW in was < 38.2 130 periods ago still showed u in scan even 140 periods ago it shows up ....so is it not working right now or am i getting some thing wrong ? thank you
(AVGC200  MINL234) / (MAXH234  MINL234) * 100

no thats not it
that only gives me > 2.5x ATR
i want min 1.5x ATR to a max of 2.5x ATR....nothing outside that

hey bruce
i thought i had asked for this in the past but did not find it here so i ask for it maybe again.... just like the ones below (using ATR) but between to points min to max not just greater then
below is yesterdays close to todays high > 1.50X ATR how do you make it to a max of 2.50x ATR thank you
H C1 > 1.50* ((AVGH14  AVGL14) / 2 + (ABS(H  C1) + ABS(C1  L) + ABS(H1  C2) + ABS(C2  L1) + ABS(H2  C3) + ABS(C3  L2) + ABS(H3  C4) + ABS(C4  L3) + ABS(H4  C5) + ABS(C5  L4) + ABS(H5  C6) + ABS(C6  L5) + ABS(H6  C7) + ABS(C7  L6) + ABS(H7  C8) + ABS(C8  L7) + ABS(H8  C9) + ABS(C9  L8) + ABS(H9  C10) + ABS(C10  L9) + ABS(H10  C11) + ABS(C11  L10) + ABS(H11  C12) + ABS(C12  L11) + ABS(H12  C13) + ABS(C13  L12) + ABS(H13  C14) + ABS(C14  L13)) / 28)

well i added 1 extra bracket after MAXH5.1 (below) no error but its not giving the right numbers its off by a long shot
100 * (C  (.764 * C6 + .236 * MAXH5.1)) / ((AVGH14  AVGL14) / 2 + (ABS(H  C1) + ABS(C1  L) + ABS(H1  C2) + ABS(C2  L1) + ABS(H2  C3) + ABS(C3  L2) + ABS(H3  C4) + ABS(C4  L3) + ABS(H4  C5) + ABS(C5  L4) + ABS(H5  C6) + ABS(C6  L5) + ABS(H6  C7) + ABS(C7  L6) + ABS(H7  C8) + ABS(C8  L7) + ABS(H8  C9) + ABS(C9  L8) + ABS(H9  C10) + ABS(C10  L9) + ABS(H10  C11) + ABS(C11  L10) + ABS(H11  C12) + ABS(C12  L11) + ABS(H12  C13) + ABS(C13  L12) + ABS(H13  C14) + ABS(C14  L13)) / 28)

yes the is what i want percentage of ATR
the one you just posted is meant to be for the 76.4 fib ...i copy and pasted it and its coming up saying formula error
and before i asked for your help i tried what you have up there except i used C5.1 ...i got no formula error but it was off some what ..i guess as you say you can't do that ...something wrong with it still anyway (your post)

yes it is the same......so are you saying that if i change the C5.1 to C6 thats the answer to my problem it will work my request if i make that change

