Login Page - Create Account

Support Board


Date/Time: Mon, 06 May 2024 22:45:24 +0000



Post From: Spreadsheet: Identifying Long / Short Winning / Losing trades

[2022-06-10 14:03:22]
Sawtooth - Posts: 3993
do you have any idea why a SELL EXIT is ignored, when using "L" Orders in Cell J72/74?
You'll also need prices in J23/J25.

Also AND($J$8<0,$J$9-3) doesnt work anymore.
You need to compare a price with J9-3:
=AND($J$8<0,E3<=$J$9-3)

Notes:
- When using alphanumeric column/row references, you don't need the @ symbol.
- You should reference study outputs with this format instead of an alphanumeric reference:
Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study