Support Board
Date/Time: Wed, 19 Mar 2025 23:55:09 +0000
Post From: Unable to reference LTP in Spreadsheet alert
| [2022-10-29 16:06:57] |
| User140688 - Posts: 13 |
|
Query: I understand that "C" refers to the last trading price of the candle and once that candle closes it becomes C[-1] and LTP is the new candle referring again to C, Now this is how things work in "Trading Systems using Alerts Study", However since I am using Spreadsheet alert, I refer the cells of the column "Last" and treat that as LTP using Similar logic ( e.g In the Buy Entry column, I'd want a condition wherein the LTP becomes equal to a specific price, and in attempts to do so, I would formulate something like IF(E3=X) X being my specific price ) I put a similar condition as above and the spreadsheet showed All False(0), I thought this might be happening because the spreadsheet has saved the Last data of each candle, and while replaying the data, as the spreadsheet would form My Hypothesis would pan out and The condition would be met at some point and thus generate the signal, However, while replaying this has not been the case and the number of times signal generated during backtest was still 0 Requested Solution: Refer Last Trading Price of the spreadsheet and be able to formulate alerts such as ones mentioned above to test the alerts in replay Kindly Help Me, I tried revisiting documentation and Forum, Couldn't find much help Thank you so much |
 sierra.png / V - Attached On 2022-10-29 16:03:54 UTC - Size: 68.69 KB - 90 views |