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: