Login Page - Create Account

Support Board

Date/Time: Tue, 07 Dec 2021 17:27:11 +0000

Transfer Spreadsheet(s) System for trading to new installation problem

[2021-10-20 00:28:58]
User612901 - Posts: 20

I have bought a new computer that I will use for SC

Have followed steps under Help Topic 15. All is good except my spreadsheets have no foumulae in them.

The workaound I have found is to
- remove the spreadsheet from Studies to Graph
- Add a new Spreadsheet System for Trading to the Studies to Graph
- Select the Spreadsheet again and Apply>OK
This then appplies the spreadsheet.... with formulae now.

- I have a large number of spreadsheets
Is there a quicker way to ensure spreadsheets contain the formulae whe I open a Chartbook? Some sort of bulk process to be applied to all .scss files?

Thanks in advance
[2021-10-20 00:33:30]
Sierra Chart Engineering - Posts: 98835
You should not have any problem like this. So you open a Spreadsheet file that should contain formulas and the formulas are not there?

What was saved in that spreadsheet will still exist.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2021-10-21 06:49:30]
User612901 - Posts: 20
For clarity, I open a chartbook(s) with .cht and .scss.

as before, the spreadsheet exists and opens, but no formulae..... only solution I have found is as described previously... but have a lot of spreadsheets

agreed what was saved in spreadsheet still exists, but only if i go through process described.... was hoping for a faster solution that could be applied to all spreadsheets
[2021-10-21 13:12:40]
John - SC Support - Posts: 12579
Are you using a specific Formula Source Sheet that is different from the sheet number?

Can you attach a chartbook and spreadsheet file for us to see if we can reproduce your situation? Follow these instructions to attach the files:

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


Login Page - Create Account