Login Page - Create Account

Support Board


Date/Time: Sat, 21 Dec 2024 18:05:12 +0000



Post From: spreadsheet trading ?

[2014-12-01 16:39:34]
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