StockFetcher Forums · General Discussion · Repost<< >>Post Follow-up
Gurok
7 posts
msg #121107
Ignore Gurok
7/26/2014 9:17:11 PM

Hello Everyone,

Hi this is a repost I accidentally posted into the wrong thread please forgive me.

I am new to stockfetcher and not learned how to program yet. The type of instrument that I trade it is best for me to catch the high and low of a particular stock. The way I am thinking how to achieve this comes from therumbledone(TRO) milking the cow filter idea. What I would like to do is create a filter in which for the last 100 days the high has been a certain percentage above the open price. Here is an example say for instance that for the last 100 days the high of the day of a particular stock has been around 40 to 50 cents 80 percent of the time, or the low of the day has been around -40 to -50 cents 70 percent of the time of a particular stock. How would I go about programming a filter that can do this using stockfetcher. Hopefully this makes sense.

Also I been having problems with this filter

set { hiop, high - open }
set { up10, count ( hiop > 0.09 , 100) }
set { up50, count (hiop > 0.49 , 100) }
set { pct1, up50 / up10 }
set {winpct 100 * pct1 }

add column up10
add column up50
add column winpct

symlist(fb)

sort column 7 descending

Keep getting syntax errors for some reason.
Thanks,


compound_gains
222 posts
msg #121108
Ignore compound_gains
7/26/2014 10:00:05 PM

Fetcher[
set { hiop, high - open }
set { up10, count ( hiop > 0.09 , 100) }
set { up50, count (hiop > 0.49 , 100) }
set { pct1, up50 / up10 }
set {winpct, 100 * pct1 }

add column up10
add column up50
add column winpct

symlist(fb)

sort column 7 descending
]



"set{ winpct," was missing the comma.

Gurok
7 posts
msg #121109
Ignore Gurok
modified
7/26/2014 10:48:12 PM

Thank you very much. I finally figured it a little bit after the first I had posted the message LOL.

Best regards,

Gurok
7 posts
msg #121110
Ignore Gurok
modified
7/27/2014 2:17:10 AM

Hello Everyone,

So here is my attempt at creating the first filter I told you all before at the beginning paragraph of this thread. As I said before the goal here was to create a filter that will tell how many times the high was greater than the open and what cent range it was over the past 100 days. If any one know an easier way to do this, and better way at doing it, it would be much appreciated, and as I said before I am not a programmer and this my first time making a filter of my own in stockfetcher so please bear with me. I thank you for your time here is the code

set{ophi, high > open }
set{up10, count( ophi > 0.09, 100)}
set{up20, count( ophi > 0.19, 100)}
set{up30, count( ophi > 0.29, 100)}
set{up40, count( ophi > 0.39, 100)}
set{up50, count( ophi > 0.49, 100)}
set{up60, count( ophi > 0.59, 100)}
set{up70, count( ophi > 0.69, 100)}
set{up80, count( ophi > 0.79, 100)}
set{up90, count( ophi > 0.89, 100)}
set{up100, count( ophi > 0.99, 100)}
set{oplo, low < open }
set{down-10, count( ophi < -0.09, 100)}
set{down-20, count( ophi < -0.19, 100)}
set{down-30, count( ophi < -0.29, 100)}
set{down-40, count( ophi < -0.39, 100)}
set{down-50, count( ophi < -0.49, 100)}
set{down-60, count( ophi < -0.59, 100)}
set{down-70, count( ophi < -0.69, 100)}
set{down-80, count( ophi < -0.79, 100)}
set{down-90, count( ophi < -0.89, 100)}
set{down-100, count( ophi < -0.99, 100)}

set{pct1, up10 up20 up30 up40 up50 up60 up70 up80 up90 up100}
set{pct2, down-10 down-20 down-30 down-40 down-50 down-60 down-70 down-80 down-90 down-100}
set{winpct, 100 * pct1}
set{winpct2, 100 * pct2}

add column up10
add column up20
add column up30
add column up40
add column up50
add column up60
add column up70
add column up80
add column up90
add column up100
add column down-10
add column down-20
add column down-30
add column down-40
add column down-50
add column down-60
add column down-70
add column down-80
add column down-90
add column down-100
add column wpct
add column wpct 2
symlist(fb)








StockFetcher Forums · General Discussion · Repost<< >>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.