Support Board
Date/Time: Mon, 03 Feb 2025 11:01:19 +0000
SPREADSHEET FORMULA DISAPPEAR AFTER SAVING AND CLOSING CHARTBOOK
View Count: 1511
| [2019-05-21 12:45:37] |
| User807128 - Posts: 18 |
|
when I create a spreadsheet study for trading , my spreadsheet formula disappears even when I save chartbook and spreadsheet separately. I have latest version of software. Thank you. |
| [2019-05-21 19:07:35] |
| |
|
The first thing to check is the Formula Source Sheet Number Input is set to reference the same sheet as the sheet which contains the chart data: Spreadsheet Study Inputs: Formula Source Sheet Number Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2019-05-21 21:23:42] |
| User807128 - Posts: 18 |
|
my chart # on the top of the study says #8 . so default study is sheet#8. however , there is a cell on sheet #8 cell D , it says >> Formula Source Sheet #4. Enter and modify formulas for this sheet on Sheet4. so when I enter formulas for buy entry , buy exit , sell entry , sell exit in sheet # 8 , it still get erased after I save the file and chart book. I tried to change cell # d , Formula source sheet # 8 but it still does not work. your help is appreciated. |
| [2019-05-21 21:26:08] |
| User807128 - Posts: 18 |
|
do I have to enter formula to sheet #4 . and repeat same formulas on sheet #8 as well for buy entry etc..
|
| [2019-05-22 00:03:55] |
| User807128 - Posts: 18 |
|
I entered the formula on sheet #4 and sheet #8 as well. it seems to be working. so it seems I have to enter formula on both sheets. please see if this is correct. I have one more question... after replaying the chart >> I see order entry right after market opens on May 17 NQ chart. I do not see order enrty box where we enter stop loss value etc. after order gets open up , it does not show buy exit around 950 AM even though moving average cross over is there. =AND (ABS($J$8)=0,CROSSFROMBELOW(AR3:AR4,AS3:AS4),A3-INT(A3)>TIMEVALUE("09:30:00")) . buy entry formula. =OR (AND(ABS($J$8)<>0,CROSSFROMABOVE(AR3:AR4,AS3:AS4)),A3-INT(A3)>=TIMEVALUE("15:55:00")) . buy exit formula. |
Private File |
| [2019-05-22 00:11:51] |
| User807128 - Posts: 18 |
|
IMAGE OF BUY ENTRY . NO BUY EXIT. PLEASE REPLY. THANK YOU. |
 MAY 17 NQ NO BUY EXIT.bmp - Attached On 2019-05-22 00:11:10 UTC - Size: 4.3 MB - 486 views |
| [2019-05-22 01:18:20] |
| User807128 - Posts: 18 |
|
PLEASE NOTE THAT RESET CONDITION ON NEW BAR >> YES HAS BEEN SET. |
| [2019-05-22 01:20:14] |
| User807128 - Posts: 18 |
|
=OR (AND(ABS($J$8)>0,CROSSFROMABOVE(AR3:AR4,AS3:AS4)),A3-INT(A3)>=TIMEVALUE("15:55:00")) BUY EXIT , CHANGED ABS($J$8) > 0 INSTEAD OF <> 0 . THANK YOU. |
| [2019-05-22 04:00:00] |
| |
|
You need to change the Formula Source Sheet Number Input in the Study Settings to 8. Your other questions are not within the scope of our support. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2019-11-01 19:50:42] |
| Chad - Posts: 234 |
|
Hi @SCE, I have a similar issue as OP - while I'd saved my modified SSfT under a new name along with the Chartbook which had it applied to several Charts (side note: did this March 2019), when I opened that Chartbook today, the formulas of the sheets as-loaded within the Chartbook were gone. If I open the spreadsheet by itself outside of that book, all's fine. So I re-opened the Chartbook & went to study settings for that SSfT, changed In: 55 (Always Set Formula Source Sheet To Chart Data Output Sheet) to 'Yes', and In: 70 to 'By Name'. After applying, the formulas are still missing, I presume due to general 'order of operations'. So question: should I remove the SSfT study then reapply it to fix this? Side note: I never noticed this happening when closing & reopening Chartbooks with my custom SSfT & formulas applied, in the release versions that were current this past spring. |
| [2019-11-06 22:45:51] |
| |
|
You have to make sure that this Spreadsheet Study setting is set to the name of the Spreadsheet File: Chart Studies: Settings and Inputs Tab >> Spreadsheet Name / DLL File and Function Name We also want you to update to the current version of Sierra Chart: Software Download: Fast Update It may relate to accessing sheets by Name rather than number when using the Spreadsheet Study. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2019-11-06 22:47:10
|
To post a message in this thread, you need to log in with your Sierra Chart account: