Support Board
Date/Time: Fri, 29 Nov 2024 05:44:41 +0000
Using the trade price in a spreadsheet to build an indicator
View Count: 359
| [2023-03-03 13:56:28] |
| trader2017 - Posts: 98 |
|
Hello, I’ve learned how to add the Spreadsheet Study to a chart and then use the chart data in a spreadsheet to do some calculations, however, I can’t figure out if it is possible to do the following. I’m not trying to use the spreadsheet for an automated system but would like to place trades on the chart with the Trade Window and then build an indicator in the spreadsheet that would use the filled price of the trade and add a certain amount to it. In the spreadsheet I can see all the data from the various indicators on the chart but don’t know what to add to have the trade price of the current position show up on the spreadsheet to be able to use it in a calculation. For example how would I use a trade filled price of $30.00 and add 3.25 to it and have a plot on the chart at 33.25 on each bar after the trade bar until the position is closed. And then it would repeat the same thing after the next trade, for example a filled trade price of $32.00 and then with the 3.25 added the next plot would be 35.25 on each bar after the trade until that one is closed. The 3.25 is just an arbitrary number I’m using for this example, I’d like to eventually be able to add a result from an indicator on the spreadsheet in place of the 3.25. Thank you. |
| [2023-03-03 14:21:59] |
| Sawtooth - Posts: 4120 |
|
You would need to use the Spreadsheet System for Trading study, since it has the Last Entry Fill Price in cell J48. Use a formula like this, e.g., in cell O3: =IF(AND($J$8<>0,$J$41>=$J$42),$J$48+3.25,O4) Set the Draw Style of SG5 to Dash. |
| [2023-03-03 16:11:36] |
| trader2017 - Posts: 98 |
|
Tom, Thanks very much for replying, I’ll try that and see how it works. |
| [2023-03-03 18:01:12] |
| trader2017 - Posts: 98 |
|
Tom, I just got a chance to try it, that’s exactly what I was looking for ! Thanks again. : ) Lisa Date Time Of Last Edit: 2023-03-03 18:01:27
|
To post a message in this thread, you need to log in with your Sierra Chart account: