Support Board
Date/Time: Sat, 30 Nov 2024 01:00:56 +0000
[Programming Help] - Exporting lvls off study to a .csv file
View Count: 2220
| [2021-02-12 20:06:01] |
| HeyUgly - Posts: 247 |
|
I have a custom study I use in Sierra, it publishes levels daily for me. I want to push thise lvls , to a ongoing csv file so I can import them into bookmap Using their cloudnotes feature. All that it requires is a csv file to show the levels. Is this possible to push the levels from the study in Sierra to a .csv? In the study sub graphs all the lvls are laid out correctly ie (sg1,Sg2,sg3,) in order for the levels etc. |
| [2021-02-12 20:38:06] |
| HeyUgly - Posts: 247 |
|
So ive got this spreadsheet study that ive been researching, i can see the levels from the study here, is there any way to export these as a .csv and get rid of all the other stuff like Bid/ask/daily high etc columns that populate on this spreadsheet?
|
zero.png| [2021-02-12 20:42:48] |
| HeyUgly - Posts: 247 |
|
heres a bigger picture, basically in this spreadsheet , my lvls are on the right, i dont need any of the Stock info OPEN HIGH LOW LAST etc. i want to push those lvls to .csv, is this possible to do inside sierra?
|
| [2021-02-12 20:50:26] |
| John - SC Support - Posts: 36350 |
|
There is no built-in study to do exactly what you want. But the closest is the study Write Bar and Study Data to File. Refer to the information here: Write Bar and Study Data To File For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-02-12 21:18:28] |
| HeyUgly - Posts: 247 |
|
so ive gotten this far, managed to get the study in the spreadsheet, and turn on to plot all the columns i want {AG - AS} now im stuck, how can i export as .csv or am i totally doing this wrong?
|
| [2021-02-12 21:41:59] |
| HeyUgly - Posts: 247 |
|
Thank you I’ll try this!
|
| [2021-10-07 04:48:53] |
| DayTraderEsad - Posts: 121 |
|
I actually have this done for me, It exported horizontals rays and and extended rectangles. Here is the link, Frederik from Simple System trading create this. Hope it helps https://www.simplesystemtrading.com/sharelevels/ |
| [2021-10-07 15:01:25] |
| John - SC Support - Posts: 36350 |
|
Here are instructions for saving the spreadsheet as text with tab delimiters: Spreadsheet Studies Special Tasks: Exporting Sheet Data Containing Price and Study Data to Text File For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-12-30 12:34:09] |
| aviat72 - Posts: 36 |
|
There is no built-in study to do exactly what you want. But the closest is the study Write Bar and Study Data to File. Refer to the information here:
Write Bar and Study Data To File Is there some code which shows how the sc.WriteBarAndStudyDataToFile is implemented; i.e. how to iterate through all the elements in the chart? I want to do something similar with some modifications. |
| [2022-12-31 06:24:18] |
| User183724 - Posts: 183 |
|
you could write this up in an ACSIL study. theres an example of how to interact with spreadsheets in the ACS_Source directory... on my machine... C:\SierraChart\ACS_Source name of file... ACSILSpreadsheetInteraction its not nearly as hard as it looks... Date Time Of Last Edit: 2022-12-31 06:50:08
|
To post a message in this thread, you need to log in with your Sierra Chart account: