Support Board
Date/Time: Tue, 26 Nov 2024 11:27:04 +0000
How transfer numbers to the chart from Quote Spreadsheet?
View Count: 2183
| [2014-04-30 19:48:44] |
| User69798 - Posts: 3 |
|
Hello, I need summation of 500 symbols by indicator calculation, or by simple Last, Volume. Yes, use Quote Spreadsheet, How transfer numbers to the chart from Quote Spreadsheet? Also, How replace data columns in Spreadsheet to other fundamentals? For example, I need streaming "Total Volume" and "Change %" Thank You. |
| [2014-05-01 07:43:12] |
| |
|
You can use the Spreadsheet study and have it reference the Quote Spreadsheet. This will accomplish what you want. Here is information about the Spreadsheet study: http://www.sierrachart.com/index.php?l=doc/doc_StudiesSystemsAlerts.php You will want to use the Chart Data Output Sheet Number input to control which Sheet the data is outputted to so it does not interfere with the Quote Spreadsheet. You can configure the columns on the Quote Spreadsheet through Global Settings >> Quote Spreadsheet Settings. 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-01 07:44:22
|
| [2014-05-01 10:00:15] |
| User69798 - Posts: 3 |
|
Link, You provided do not contain word "quote" at all, as well as Quote Spreadsheet. How have it reference to Quote Spreadsheet from Spreadsheet Study please? Thank You |
| [2014-05-01 10:03:46] |
| |
|
When you follow through the step-by-step instructions on the page linked to, you will be setting the Spreadsheet Name. That name is the name of your Quote Spreadsheet.
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 |
| [2014-05-01 10:41:29] |
| User69798 - Posts: 3 |
|
Reference work, Thank You Now problem inside sheet, look at the picture please Row1 is original only from Quote Sheet, other row and column replaced during Study entering process, so formula in error Date Time Of Last Edit: 2014-05-01 13:17:07
|
 Sierra_1.png / V - Attached On 2014-05-01 10:38:44 UTC - Size: 64.05 KB - 442 views |
| [2014-05-01 20:01:20] |
| |
|
This is why we previously said this: You will want to use the Chart Data Output Sheet Number input to control which Sheet the data is outputted to so it does not interfere with the Quote Spreadsheet. You need to have the chart use a completely different Sheet within the Spreadsheet. You can use sheet cell references to reference the data on another Sheet within the Spreadsheet window. 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-01 20:02:06
|
To post a message in this thread, you need to log in with your Sierra Chart account: