Support Board

Date/Time: Thu, 25 Apr 2024 17:43:19 +0000

Post From: SpreadSheets - Referencing 'Last Entry Trade DateTime' (Cell J42)

[2020-01-16 03:22:49] Link To Thread - Link To Post [Go To First Post]
a Gem Tree - Posts: 60
Thank you Tom - I kinda wrote my own stuff, cus I just don't understand the code above. So for anyone searching google for this stuff, here's a very simple solution, but one that uses 2 columns: Column 1: - Written in Column S... =AND(A3>$J$42) Column 2: =IF(AND(S3=1,S4=0), (INSERT your own function) ,0) Note that, the column you are interested in, will be the 5th row. So, if you want the last price of your trade entry bar, you must type, E5, in the 3rd row. This means that you will not be able to reference the entry bar until 2 bars later. But if you guys have a better solution as to how to write it, let me know.