Home >> Support Board

Support Board

Date/Time: Fri, 22 Nov 2024 21:49:58 +0000

How to Post a Message for Support

[Programming Help] - Opening a custom spreadsheet study automatically

View Count: 161

[2024-09-23 08:16:02] #1 [Go To First Post]
Julien Vieillard - Posts: 10
Hi everyone, I'm having a bit of trouble with Spreadsheet. When I add the "Spreadsheet Study" to my chart, the "DefaultSpreadsheetStudy.scss" file automatically opens in a new tab alongside my chart. I'd like to replicate this behavior for my own custom study. I've managed to interact with my spreadsheet from my custom study without any issues. However, I'm struggling to find a way to make my own spreadsheet open automatically when I add my custom study to the chart. I've searched through the ACSIL documentation but haven't found any specific function to achieve this. Could anyone please point me in the right direction? Any help would be greatly appreciated.

[2024-09-24 01:18:56] #2 [Go To First Post]
ForgivingComputers.com - Posts: 960
In the Spreadsheet Study settings, look for the Spreadsheet Name box in the lower left. Put a unique name in there, and it will save the SCSS as the new name.

[2024-09-24 19:42:30] #3 [Go To First Post]
Julien Vieillard - Posts: 10
Thank you for your help. I found the "DLLName.FunctionName" box in the bottom left, but I can't modify the name. The box is grayed out. Is there a way to change the name directly from my custom study ?

[2024-09-24 19:58:18] #4 [Go To First Post]
ForgivingComputers.com - Posts: 960
I think you looking at the wrong study. Look at the Spreadsheet Study settings window.


Screenshot 2024-09-24 125300.png / V - Attached On 2024-09-24 19:57:27 UTC - Size: 113.29 KB - 31 views

[2024-09-25 05:00:25] #5 [Go To First Post]
Julien Vieillard - Posts: 10
Thank you. I'm not trying to change the name of the spreadsheet linked to the 'Spreadsheet Study'. Instead, I'm trying to replicate its behavior. I've created my own custom study that interacts with my own spreadsheet. However, I want my custom spreadsheet to open in a new tab when I add my custom study to the chart, just like the 'Spreadsheet Study' does. Is there a way to achieve this ?

[2024-09-26 05:08:12] #6 [Go To First Post]
Julien Vieillard - Posts: 10
Hi everyone, I was able to resolve my issue with orders not being filled at my desired entry price by enabling an option. You can find it in "Global Settings >> General Trade Settings >> General >> Simulated Order: Use Last Trade Price For Fill When Bid Ask Beyond Last Trade Price" and select "Yes". Thanks to everyone for your help.

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