Login Page - Create Account

Support Board


Date/Time: Tue, 14 May 2024 19:30:38 +0000



spreadsheet trading study - Referencing High / Low of historic price bar

View Count: 677

[2017-05-09 18:56:55]
User85946 - Posts: 5
Hi,

I am creating a spreadsheet tradig system on a 1 Hour timeframe chart. Once filled and in a trade, I have a specified time of the last entry in cell J42. For use in my Buy Exit code in cell L3, I would now like to refer to the Low price of the bar preceding the bar of my entry. How can I create a formula that would refer to this price?

Many thanks,

Torbjorn
[2017-05-09 20:17:02]
Sierra Chart Engineering - Posts: 104368
You would need to use this function:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#GetCorrespondingMatch_Function

This can search for a particular time in the A column and reference a cell in another column.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account