Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 09:52:19 +0000

How to Post a Message for Support

Use Excel for spreadsheet

View Count: 2504

[2017-09-16 22:21:04] #1 [Go To First Post]
toews&kane - Posts: 209
Hi there, does this option work? Gets to be way easier to work with numbers. I tried it it continuously open an Excel window after I close it but the worksheets are just blank. Data are not porting over.


Screen Shot 09-16-17 at 06.19 PM.PNG / V - Attached On 2017-09-16 22:19:57 UTC - Size: 41.95 KB - 468 views Attachment Deleted.

[2017-09-17 02:12:46] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
This is explained here: https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#UseExcel Give us one or two items why it is easier to work with numbers in Excel. And we will see if we can possibly work on one or two of those. 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

[2017-09-17 06:08:40] #3 [Go To First Post]
toews&kane - Posts: 209
I think for me it's a couple of annoyances. 1. I can't highlight cells in bulk, meaning if I try to take a column and do a highlight I have to select a smaller range and go > right click> cell properties. The three clicks are fine for me but just not able to highlight an entire column/row 2. Freeze panes - if I try to freeze columns it only would let me go as far as to column M. You may think why would this guy want to freeze panes further than M there's no screen space but, I guess this one is just a minor annoyance, maybe on a scale of 10 i say 5/10. Generally it's the aesthetics part of it to make it easier for me to sift through and analyze the numbers with the highlight and freeze panes. One other thing that we can improve on is when I do data sorting. Sometimes I play around with the data sorting and A through J is pretty good, if I do a sort that will bring the headers to the bottom it automatically regenerates it at the top. But it doesn't do that from AA onwards. It's just a annoyance if I do a mistake on the data sort on the sheet I generally have to start over, there's no undo. 3. One thing that I really hated for years is if I add any studies to the chart after I've added the spreadsheet study the headers will be shifted and misaligned, if I have added a column for some calculations in the back. ( I guess I should use K through Z) and I guess pumping the data through to excel wouldn't help this. I am using excel 2016 btw. Cheers, W

[2017-09-22 16:51:54] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We will look these over. 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-04-19 12:51:11] #5 [Go To First Post]
The_last_call - Posts: 8
Hi I have the same question. I want to build my own screener includet data of the ADX and other studies. I have done this by using excel. Now I searching for a Data-Feed. In your spreadsheets I can add the values of the studies wich is great. Is it possible to use a Querry to this for excel?

[2019-04-22 19:57:13] #6 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
What we recommend doing is creating an alert formula to check for the study conditions and then you can run a scan. All of this is documented here: Study/Chart Alerts And Scanning For data we recommend using the Sierra Chart Historical Data Service: Sierra Chart Historical Data Service 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-04-22 19:58:36

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