LOWEST[254] does not work for relatively new stock

Forums › ProRealTime English forum › ProScreener support › LOWEST[254] does not work for relatively new stock

Viewing 4 posts - 1 through 4 (of 4 total)
  • 07/30/2017 at 7:32 AM #41993
    benzhang1986

    I am trying to find the lowest price of a stock for the past N weeks. For BABA, when I use LOWEST[254] applied to weeks, BABA get filtered out in the screener result because it is a relatively new stock and does not have 254 weeks of history. I would think if the stock does not have enough history, LOWEST will just return me the lowest in the period that is available for that stock. But it just filter them out, which is not what I want. So my question is how can I achieve what I want? Is there a variable that captures the number of bars available for a given stock so I can use that variable? eg. LOWEST[NumbersOfBarsAvailable]

    Also, what if I wanna apply screener to data prior to 254 weeks ago. Is there a feature like that? Can I apply unit bar to months, in addition to days and weeks? That would be another solution.

    ps: LOWEST[254] is the max I can go it seems. If above variable(NumbersOfBarsAvailable) exists, and the value is more than 254, I guess it would not work either. I would have to do LOWEST[MIN(254,NumbersOfBarsAvailable)] I guess.

    Any suggestions and/or answers to my above questions will be greatly appreciated!

     

    07/30/2017 at 10:14 AM #41997
    Nicolas

    254 bars is the max history available in ProScreener. BARINDEX will give you the number of bars read in the history, and since history is read from left to right, your code snippet:

    should work.

    A simple test with this dummy screener code should return you the quantity of bars available for each stock:

    (not tested, could not work 🙂 )

    08/01/2017 at 3:06 AM #42147
    benzhang1986

    barIndex actually means something totally different. I think it only means something when you are doing a for loop of some kind. I don’t think your code will work. Can you try it?

    08/01/2017 at 9:18 AM #42162
    Nicolas

    Did you test yourself? It works, but we made a wrong use of LOWEST 😐

    Please find below the good code and the result of a stock with only 14 bars in a weekly chart, bars quantity seems to be correctly returned in the criteria column of the screener window.

     

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)

Find exclusive trading pro-tools on ProRealCode Marketplace

Similar topics:
backtesting does not work which a great amount of time units
why does my indicator not work for currency?
accountid does not have permission for epic + locale combination
does sest stop trailing command work in real?
mlutiple ut – does not take the large one
position does not exist
stock comparison with sector indices or other stock within the sector
the screener does not show the same values that the indicator
6 jan 24 prt not available – too long to respond
alert not triggered

Create your free account now and post your request to benefit from the help of the community
Register or Login