Support Board
Date/Time: Sat, 23 Nov 2024 14:30:55 +0000
Post From: How to get fill values into Spreadsheet System for Trading
| [2013-07-05 03:32:48] |
| rick e - Posts: 51 |
|
Hi folks. I've been using Sierra Chart for a while now and consider it to be without a doubt the best documented and feature-packed market software that one could use today (and believe me, i've tried a good many of them over the years and have found them wanting- I am 67 yrears old). Now at this point I have one question and here's the question : I love the spread between Soybeans and Corn and use the 'Difference" Study (line version) to display this 'Spread"on a chart and further, the "Spreadsheet System for Trading" study to provide a spreadsheet to display the statistics of the trade etc. I enter the spread manually as I see it on the chart (not using automatic "Buy Entry" or "Sell Entry") but using the Trade Dom and manually trading as close as possible to simultaneous execution as I can. Let's say maybe Long July Soybeans and Short Dec. Corn. I see the Difference (Spread) all down Col AA on the spreadsheet and have established formulas in "Buy Exit" and "Sell Exit" in line 3 to exit simultaneously under certain conditions but the thing that I need the most is the AVERAGE FILLS for the long beans and short corn in columns ON THE SPREADSHEET so that I can use them in another formula TO HAVE AN ABSOLUTE FIXED POINT IN THE SPREAD THAT I WAS FILLED AT and thus giving me the capability to plug this number AUTOMATICALLY into the formulas in "Buy Exit" and "Sell Exit"as the "Difference" changes rather than having to manually first calculate the value of the spread at the time I was filled, produce a fixed "difference" number and then manually type this into the formulas into the "Buy Exit" and "Sell Exit" cells which as you must know is really! hard if not impossible to do in a "fast" market like beans quite often is! Any help here would immensely help me and make me able to control my trading if not in a fully automatic way, but in a very effective way. Sincere Thanks - Rick P.S. I have it now so that the manually entered trades will exit automatically and pretty well simultaneously when certain formula conditions are met and that even took me a quite a while to figure out! |