Login Page - Create Account

Support Board


Date/Time: Fri, 19 Apr 2024 13:01:18 +0000



acsil inquiry

View Count: 1015

[2014-05-11 20:12:06]
enemyspy - Posts: 304
Ok, I now have a pretty awesome spreadsheet app which reconstructs volume at price data, as well significant data points within the profile from a 1 tick range chart.

However as many of us who have likely already done this know, it is not really practical to have very many instances or profiles contained on spreadsheet if it depends on an endless list of formulas remembering all of the info as it will overload the cpu.

The question: Would ascil make it possible to create a custom study which basically acts as a macro to copy and paste the number values from a specified range of cells to the next available empty row of a different sheet, everytime say K3 of the study returns a true value?


[2014-05-11 23:13:27]
enemyspy - Posts: 304
I realize, especially after doing a thread search, that already asked this question numerous times...My bad..The one answer I received upon reviewing the threads is that I would need to try a macro program.

I just wanted to check one more time definitive, yes or no, if ascil can do this, if the one doing it were to really know what they are doing with it, or is it definitely not possible through user access?
[2014-05-12 17:31:14]
Sierra Chart Engineering - Posts: 104368
ACSIL cannot control spreadsheets in this way. The only thing that ACSIL can do in regards to spreadsheets is access the values of the Spreadsheet formula columns by referencing the Spreadsheet Study Subgraphs itself on the chart.

This would be the same as getting the results of a Moving Average study on the chart, by referencing its study subgraph.

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: 2014-05-12 17:31:27

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

Login

Login Page - Create Account