StockFetcher Forums · Filter Exchange · FRAMA help, please<< >>Post Follow-up
graftonian
764 posts
msg #147012
Ignore graftonian
3/19/2019 6:39:15 PM

How can I find the high and low of close between 126 days and 63 days
Fetcher[
optionable
Average Volume(30) > 12345678
CHART-TIME = 126 DAYS
/***********
FRAMA = 126
FC = 4
SC = 300
*********/
/*FIND HL1, HL2, HL */
set{HLhi, close 126 day high }
set{HLlo, close 126 day low}
set{HL2hi, close 63 day high}
set{HL2lo, close 63 day low}
/* */
add column separator
add column hlhi and add column hllo
draw price line at HLhi and draw price line at HLlo
add column separator
add column hl2hi and add column hl2lo
draw price line at HL2hi and draw price line at HL2lo
/*How to find close high and low between 126 days and 63 days*/
]



Cheese
395 posts
msg #147018
Ignore Cheese
3/19/2019 10:52:23 PM

Fetcher[

optionable
Average Volume(30) > 12345678
CHART-TIME = 126 DAYS
/***********
FRAMA = 126
FC = 4
SC = 300
*********/
/*FIND HL1, HL2, HL */
set{HLhi, close 126 day high }
set{HLlo, close 126 day low}
set{HL2hi, close 63 day high}
set{HL2lo, close 63 day low}
/* */
add column separator
add column hlhi and add column hllo
draw price line at HLhi and draw price line at HLlo
add column separator
add column hl2hi and add column hl2lo
draw price line at HL2hi and draw price line at HL2lo
/*How to find close high and low between 126 days and 63 days*/
set{HL3hi, close 63 day high 63 days ago} /* Cheese's suggestion */
set{HL3lo, close 63 day low 63 days ago} /* Cheese's suggestion */
add column separator
add column hl3hi and add column hl3lo
draw price line at HL3hi and draw price line at HL3lo
]



graftonian
764 posts
msg #147020
Ignore graftonian
3/20/2019 10:28:14 AM

Cheese, That was too easy, I've been staring at this s*** for too long.
Graf

Cheese
395 posts
msg #147022
Ignore Cheese
3/20/2019 11:11:45 AM

Graf,
I rushed to post my suggestion late last night so you can do something wonderful with FRAMA.

graftonian
764 posts
msg #147029
Ignore graftonian
3/20/2019 6:35:14 PM

Well guys, I think we are SOL on this one. Log10 and EXP functions are needed, Any ideas?
I am continuing this exploration on Libre officecalc, and need help in downloading closing data for a few stocks for 6 months or so Again, any ideas?
Graf

scvidar
62 posts
msg #147030
Ignore scvidar
3/20/2019 7:37:24 PM

Nice! Thank you so much.

Cheese
395 posts
msg #147031
Ignore Cheese
3/20/2019 11:22:29 PM

Graf, you may want to ask the math wonks of this forum who are still around, e.g. nibor100
Fetcher[
/* https://www.stockfetcher.com/forums/Announcements/More-Math-Functions-Available/32061/-1/32061 */
symlist(BA)
draw log10(RSI(14))
draw exp(RSI(14))
]



Cheese
395 posts
msg #147032
Ignore Cheese
3/20/2019 11:51:57 PM

SAFeTRADE has a filter that uses LOG10 here

https://www.stockfetcher.com/forums/Filter-Exchange/Expansion-and-Compression-using-Hull-MA-within-Bollinger-Ban/138845/-1/138845

SAFeTRADE modified 10/24/2017 9:36:56 PM

Fetcher[
set{atrsum, sum(atr(1),10)}
set{x,5}
set{x2, log10(x)}
set{diff, high 10 day high - low 10 day low}
set{temp, atrsum / diff}
set{a, log10(temp)}
set{chop1, a / x2}
set{chop, chop1 * 100}

draw chop line at 80
draw chop line at 61.8
draw chop line at 32.8


set{buy, count(rsi(2) above 70,1) * count(rsi(3) above 70,1)}
set{sell, count(Bollinger %B(8,2.0) crossed below .5,1)}

set{fast1,cwma(close,4)}
set{fast2,2 * fast1}
set{fast3,cwma(close,8)}
set{valfast,fast2 - fast3}
set{fastavg,cwma(valfast,3)}
symlist(spy,vxx,dia,qqq,xiv)
draw Bollinger %B(8,2.0) line at .5
draw rsi(2)
draw rsi(3)
draw buy
draw sell
set{my_avg, fastavg}
set{sigma2, cstddev(fastavg,2) * 10.0}

set{upper_band, my_avg + sigma2}

set{lower_band, my_avg- sigma2}
and draw upper_band on plot price
and draw upper_band2 on plot price
and draw lower_band on plot price
draw my_avg on plot price

add column buy
add column sell
add column rsi(2)
add column rsi(3)
add column Bollinger %B(8,2.0)
add column chop
chart-length is 3 months
]



StockFetcher Forums · Filter Exchange · FRAMA help, please<< >>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 2018 - 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