Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 28 Apr 2024 14:36:41 +0000
[Programming Help] - Spreadsheets trading read from a text file
View Count: 564
| [2020-04-14 15:18:25] |
| User852086 - Posts: 41 |
|
Does anyone knows if it's possible to read from a text file and input it into the spreadsheet cell? (Short lenght, 0 or 1) One or two digit would be then substituted into the typical calculation of spreadsheet formulas within SC for a buy or sell signal. I'd like to use spreadsheet instead of ASCI due to the ease of use to quickly get going. |
| [2020-04-14 21:14:14] |
| |
|
The only automated way to do this would be to use ACSIL to populate the Spreadsheet. You could then do everything else using the Spreadsheet itself. Refer to the following ACSIL functions to help: 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 |
| [2020-04-15 08:32:33] |
| User852086 - Posts: 41 |
|
Thanks It would be very helpful if you could share an example of the ASCII function to read an external file and update the spreadsheet cell. Variables to be customized would be: Input --> (text file name & location) | (rows/columns or string position) Output --> (SS name) | (SS Cells) |
| [2020-04-15 13:05:05] |
| Sawtooth - Posts: 3980 |
|
If you are doing something simple in Excel, you could instead add a sheet not associated with a chart, where it could be referenced directly. The added sheet is blank in all cells. You could also get data from a chart's sheet, perform calculations, and pass it back. |
| [2020-04-16 04:57:31] |
| User852086 - Posts: 41 |
|
The data is external and can be saved to any format I decide it to. I'm just not sure how can this be imported into the SS cell for trading. From what support is saying it can be done with ASCII. It would be helpful to share the example of that file instead of reinventing a wheel from those dry docs. |
To post a message in this thread, you need to log in with your Sierra Chart account: