Support Board
Date/Time: Mon, 25 Nov 2024 16:48:10 +0000
[User Discussion] - Exporting data/studies in quoteboard format to Excel or Text file
View Count: 1913
| [2013-07-30 18:22:35] |
| gabby alindogan - Posts: 49 |
|
Hi. I am trying to import data to Excel using SC's spreadsheet study. I need to get 4 studies (ie mov avg,adx,custom1,custom2) for 20 tickers-aapl,ibm,etc.... Is there a way to layout the tickers in quotepage format from cells A1 to cell A20, and then get dynamic from the 4 studies for all the 20 tickers onto columns b,c,d,e? If not, is there a way to output it to a text file where I can parse it out using VB? Can the "bar data to file" study write the above example of studies? |
| [2013-08-01 05:37:55] |
| |
|
Refer to this page: https://www.sierrachart.com/index.php?l=doc/helpdetails69.html One thing to be aware of is that we are going to be updating the files on that page to use a single Spreadsheet and instead of 2 Spreadsheets. So you may want to wait until we get that done. We'll try to have it done tomorrow. 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-02-23 00:18:55] |
| gabby alindogan - Posts: 49 |
|
Hi. My Sierrachart writes OHLC data into a csv text file using "write data to file" and I import this file into another application using javascript loaded in Windows Task Scheduler to fire every 1 minute for data refresh purposes. Since Javascript reads the entire dataset per ticker and all I am interested in is the last 1 minute ( since the other minutes have already been loaded previously). Can you please suggest an automated way to combine old csv and new csv file so that only the last minute is imported to speed up process? Thanks. |
To post a message in this thread, you need to log in with your Sierra Chart account: