Click here to Login





                                                   How to compute the Highest Low

  0

0
JC
2020-09-01 14:37:54


Hi, I want to create a system that uses the HHV and LLV values
My trailing stop, is the highest value of the lowest low until the close is less than this value

a=LLV(Low,6);
b would be the highest of a (a trailing stop as it were) of the LLV until the close is lower.

My buy is similar in that the close>Lowest HHV(High,6) so a trailing stop of the highs

i can't find a highest function, there is a highest since but cant see how to bring this into my formula

any help would be much appreciated



QuantShare
2020-09-02 08:54:50

  0

Best Answer
Hi,

LLV is the lowest and HHV is for the highest.

For the highest value of the lowest low:
a = hhv(llv(low, 6), 6);



JC
2020-09-02 09:11:10

  0

OK thanks, not quite what i had in mind only because the use of the LLV over any period is still likely to fall, after the 6th period for example
whereas i dont want it to fall
I'll still try to use the above. thanks for the response however, its very much appreciated



QuantShare
2020-09-03 11:59:38

  0

I am not sure what you mean here. Can you please explain this in details? What do you mean by "over any period is still likely to fall"?


JC
2020-09-03 15:39:29

  0

apologies for not being more precise
lets say the LLV(low) over a time period are 4,4,4,5,4,5,3,4,4.....
The highest of this series is 5. I don't want my value to get lower until my close falls below this (5), so i want the highest of any series (irregardless of time) until the close falls below...ie its the same as a trailing stop, can only keep getting higher or stays the same
by using the highest LLV(6) i will get 5, until llv becomes 3, then it will go back up to 4.

hopefully that makes sense. im trying to create a trailing stop, it can never get lower, until that stop is hit
I can't use the HHV(LLV,L,12) as that means the stop is not as close as 6, so i cant use a longer lookback period



QuantShare
2020-09-04 11:11:06

  0

Given your example, the highest of llv is 5 but the close price of the other bars could be lower than 5. The first bar has a low of 4 but the close could be 4.5, which is lower than 5. So that does not make sense with " I don't want my value to get lower until my close falls below this (5)".

Did you try just:
a = llv(low, 6);



JC
2020-09-05 11:04:45

  0

in this series, yes you are right, the close be less and thats absolutely fine, thats the point of a trailing stop
the first bar has a low of 4, so this would be my highest low. next is 4, next is 4 etc etc until 5. now my highest low is 5. then its 4, but my highest low is still 5, then its 3, my highest low is still 5..its trailing until my close closes less than 5.

if i used a llv(low,6) clearly i have a low of 4,4,4,4,5,3..now my stop is getting lower. so now if my close was 3 i should have been stopped out..thats not a trailing stop.

I just want the highest in a time series



No more messages
0




Reply:

No html code. URLs turn into links automatically.

Type in the trading objects you want to include: - Add Objects
To add a trading object in your message, type in the object name, select it and then click on "Add Objects"










QuantShare

Trading Items
High to low stock pattern for the close price
Stocks with the highest Volume Increase
Stocks outperforming the S&P 500 with low volatility
Top 20 stocks with the highest 10 day rate of change - Current an...
How far are the close prices from the support line

How-to Lessons
How to plot a stock using different periods in the same chart
How to use the Fibonacci retracement drawing tool
How to dynamically update the settings of an indicator
How to plot the relative performance of several stocks/indices
How to scale and move the chart Y-axis

Related Forum Threads
Highest high and Lowest low difference intraday chart
How do you retrieve the entry and exit price for a position?
How do I refer to the close price of another symbol in a formula?
How to view the raw data files?
How can I view signals rejected by the simulator?

Blog Posts
How to Pick the Best Trend Indicators
How to create the advance/decline market breadth indicator
How to create market indicators using the composite function - Pa...
Buy the best/top rated stocks or how to create powerful rank base...
Trading System: Buy stocks with the highest Sharpe ratio









QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright 2020 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.