Support Board

Date/Time: Mon, 06 May 2024 19:51:47 +0000

Post From: spreadsheet trading ?

[2014-12-01 16:39:34] Link To Thread - Link To Post [Go To First Post]
User120827 - Posts: 77
When you use a formula like: bv3 > bv4 in order to signal an increase in something like a MACD for instance. What is the proper formula so you can show historical signals for backtesting. I am familiar with a range for crossovers like : =crossfrombelow(AB3:AB4,AC3:AC4) But I cant figure out how to write formula for a simple "greater than last bar " signal. Like " bv3>bv4 so as to get historical signals to allow me to backtest it. thanks shane Date Time Of Last Edit: 2014-12-01 16:40:18