Support Board
Date/Time: Sat, 23 Nov 2024 08:44:11 +0000
Post From: Audible alert on Spreadsheet study when cell value exceeds a certain number
| [2024-09-07 06:51:12] |
| trader2017 - Posts: 98 |
|
Skip to Edit 3 if you don't have time to read all of this. I kept it here if anyone else is trying to accomplish the same thing. --------------------------------------------------------------------------------------------------------------------------------------------- I’m trying to get this to work, I read through the documentation you referenced. So far, I have part of it working. The charts I’m interested in totaling profits from are =Sheet21!$J$10 =Sheet22!$J$10 =Sheet23!$J$10. My “profit” spreadsheet references those sheets in the workbook and calculates the total profit from each of them in cell $A$6. In Sheet21 at $K$1 which is above the words “Buy Entry” I wrote: =profit!$A$6 and it returned the profit from $A$6 when I ran a simulation. So far, so good. In the Spreadsheet System for Trading study on Chart 21 it has an ID number of 99. I selected the Settings button. One of the Input Names is Column K Alert (In:30) and I set that to Alert 10. Not sure if I had to do that or not. Then I went to the Alerts Tab and wrote: =ID99.SG1>100. I selected the Alert sound as Alert 10 checked the Enabled box, tried to select the Reset Alert Condition on New Bar but after I selected the OK button and then went back to see if it stayed checked, the Enabled checkbox was still checked but the Reset Alert Condition on New Bar went back to unchecked status for some reason, it kept unchecking itself when I tried again. In simulation there was no audible alert of Alert 10 when the profit reached 100 and stayed over 100. One confusing thing is that ID99.SG1 refers to the Buy Entry (SG1) in the Subgraph tab in the Study Settings for ID99. I thought maybe the Input Name Column K Alert which had in parentheses In:30 meant that I should substitute SG1 with SG30 but that didn’t work either. I'm not running an automated trading system with this study, I'm only including it to be able to calculate the total profit from different charts. What am I doing incorrectly? Edit 1: I think in your previous replies, you may have been thinking that I was using the Spreadsheet study. I’m using the Spreadsheet System for Trading study. I just added the Spreadsheet study and noticed that column K does not say Buy Entry. Am I supposed to be using column O in some way for the Spreadsheet System for Trading study? Edit 2: If I place =profit!$A$6>100 in the Spreadsheet System for Trading study on Sheet 21 in $O$3 and then take one of my other studies such as Daily OHLC and add to the alert tab: =ID99.SG5=1 (which is column O's subgraph) then I will get an audible alert and also the Reset Alert Condition on New Bar will stay checked so the alert will keep playing for each subsequent bar. The only problem is that as soon as I save the chart studies as a template the formula =profit!$A$6>100 disappears from $O$3. I don't know how to enter a formula in Sheet 21 column O and have it stay there constantly. Edit 3: I got it to work!!! From reading other questions about data disappearing from cells one of the answers from Sierra Chart was the following: It sounds like the Formula Source Sheet Number input with the Spreadsheet study is not set correctly. This is documented here: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#FormulaSourceSheetNumber So I kept everything the same that I wrote about above but added =profit!$A$6>100 to $O$3 on Sheet 1 even though I’m not using Sheet 1 for the charts that I’m trying to total the profit from. Sheet 1 automatically copied that formula to all the other sheets in the workbook. Now the alert plays in simulation and the formula does not disappear when saving the spreadsheet to a study template. Thanks again for your help. Just wanted to mention while I’m writing that I really appreciate Sierra Chart, it’s my favorite trading application of all the ones I've worked with, and the support is excellent too. Lisa Date Time Of Last Edit: 2024-09-07 10:39:39
|