Login Page - Create Account

Support Board


Date/Time: Mon, 30 Dec 2024 03:13:18 +0000



Spreadsheet study formula is not saving

View Count: 1733

[2015-02-21 17:09:26]
User48557 - Posts: 138
I use this formula =IF(AND(WEEKDAY(A3)=1,A4-INT(A4)<TIMEVALUE("17:00:00"),A3-INT(A3)>=TIMEVALUE("17:00:00")),B3,K4) for 10 different markets on 10 different charts on my watch list. Originally I only had this formula for 5 markets. Then i added it to 5 more markets it worked just fine for the time being. Then i saved and closed my platform . The next day I opened up my platform and the 5 different spreadsheets that i newly added , did not save the formula i added in cell block K3.

I attached a image of what happens when i open up my charts.


I re-added the formula then saved the platform and closed it down. I've done this numerous times i've even created new spreadsheets in hope that they would save. Every time the same thing happens. The original 5 work fine and the new 5 pop up blank in cell block K3 and the spreadsheets open above my charts.
imagess.GIF / V - Attached On 2015-02-21 16:52:12 UTC - Size: 265.75 KB - 386 views
[2015-02-21 18:09:27]
Sawtooth - Posts: 4143
If you set to the same Chart Region on all spreadsheet studies, you can use the same-named spreadsheet for all charts in the chartbook. (You don't necessarily need a separate spreadsheet file for each chart.) By default, each Sheet# (in the upper left corner dropdown) will correspond to the chart#, and this is the sheet that the formulas need to be on.

If you are using the same formula on all sheets, you can set one sheet to be the master so that you only have to edit it in one place. This is done by setting the Formula Source Sheet Number of every same-named spreadsheet study to the same value.

But specifically to your issue, the missing formulas are related to formulas entered on sheets that do not correspond to the chart #, or the Formula Source Sheet Number setting does not correspond to the sheet with the formulas.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account