Home >> Support Board

Support Board

Date/Time: Sat, 27 Apr 2024 06:29:51 +0000

How to Post a Message for Support

[Programming Help] - Writing to Sierra Spreadsheet via External Application

View Count: 1256

[2019-01-25 22:57:55] #1 [Go To First Post]
ILIM KIRGIZ - Posts: 187
I'm LMAX user and as they do not supply "balance" and "available to trade amount" value via FIX protocol, my programmer developed an interface to get this data via API. Now I need to push this data into my study and I would like to be able to use scss files for this purposes. What would be your guidance to be able to update a Sierra spreadsheet file via external application? Thanks.

[2019-01-26 05:00:49] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We think It is best to use ACSIL and read that balance data from a simple operating system file. There is no need to involve spreadsheets. But if you have read this in using ACSIL and you need to access the data using a spreadsheet you can use these functions: sc.GetSpreadsheetSheetHandleByName() sc.SetSheetCellAsDouble() 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-01-26 05:02:20

[2019-01-26 17:32:14] #3 [Go To First Post]
Chad - Posts: 231
SCE, could you elaborate a bit on the reading of such data from an OS file, as you mentioned? Type of file, basic process, etc? This is of interest to some of my external data access plans.

[2019-01-26 20:32:22] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
You can use whatever type of file that you want. Just write to the file and maintain a lock on the file when writing and then read the file in ACSIL. This is all. 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-01-27 12:21:43] #5 [Go To First Post]
ILIM KIRGIZ - Posts: 187
My programmer also needs a little bit more elaboration on this one. Which function of yours should be used to read from the txt file? Thanks.

[2019-01-30 10:03:59] #6 [Go To First Post]
ILIM KIRGIZ - Posts: 187
He can read the file but have issues with parsing. Do you have any example for that?

[2019-01-30 10:39:18] #7 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
This is not within the scope of our support. This does not make any sense whatsoever, that this question is being asked to us. We have absolutely no idea the answer. You figure it out. You are the one writing the code. This is one reason we need to start charging extra for support. There simply is no other possibility and this only exemplifies why this policy must be put in place. 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-01-30 10:50:09

[2019-01-31 18:04:24] #8 [Go To First Post]
ILIM KIRGIZ - Posts: 187
Thanks, but I hired a developer inside from your suggested partners https://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php and I pay for the development. So the question wasn't mine. You could politely tell me that you didn't have such an example or If you have one you could share as this might be a request of previous users as well. I'm also an engineer and I worked for Philips Healthcare years ago, supported users of medical software at tier 3 level. so I can understand your overload and I respect what you do but not the attitude. Anyway thanks.

[2019-01-31 19:01:10] #9 [Go To First Post]
ILIM KIRGIZ - Posts: 187
He figured out how to read by the way. Thanks.

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