Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 10:00:21 +0000



Post From: J80 attached order for spreadsheet ?

[2014-08-11 16:02:15]
Sawtooth - Posts: 4120
SC documentation is actually very good. It is comprehensive to the point of being overwhelming at times, but this is a good thing because you can did deep when the need arises. Everything I know about SC spreadsheet studies, and what I've shared on my blog, comes from their documentation, lots of trial and error, and an occasional clarification on this forum. So dive in, and play around. I don't know of any other way.

The point of J80 and J81 is to allow the placement of Attached Orders from spreadsheet formulas. And with the addition of the Trade Management By Study study, you can even move them with spreadsheet formulas. Very cool.

When using the Spreadsheet System for Trading study to make entries/exits, 'write' cells in column J override respective settings in the Trade Window. This includes Order Quantity in J26, entry/exit types in J71-J74, entry/exit prices in J22-J25.
With 'Use Attached Orders' checked, if either J80 or J81 is not blank, the twconfig and related Trade Window settings are not used.
With 'Use Attached Orders' unchecked, if either J80 or J81 is not blank, entries have no attached orders.