Support Board
Date/Time: Wed, 19 Mar 2025 02:22:25 +0000
IB information
View Count: 536
| [2022-10-06 23:25:34] |
| coachted - Posts: 383 |
|
is there a way to download the open high low close and Initial balance high and initial balane low on a daily chart into excel? for example I want to see 10/6/2022 open high low close initibalance hi (high of the first hour) and the intial balance low (the low of the first hour) I tried on a daily chart the IB info is the actual high and low of the day...I tried on a 30 min but then I gives me incorrect info |
| [2022-10-07 14:08:04] |
| John - SC Support - Posts: 38782 |
|
In terms of getting the Initial Balance on the chart, you can not do this on a Daily chart. The chart would have to be in increments that are the period you want or less, but are evenly divisible into that period. In other words, you are wanting the first 1 hour, so you need chart bars that are 1 hour or less. You can do 1 min, 20 min, 30 min, etc. but you could not do 45 min, as 2 45 minute bars do not give you 1 hour. There are a number of studies you could use to determine the Initial Balance, but it would be simple enough to use the Initial Balance study. Refer to the following: Initial Balance And then, in terms of exporting the data - if you just want an occasional capture, then you would use the Edit >> Export Bar and Study Data to File. But, if you want to get continuously updated information, then you would use the study called Write Bar and Study Data to File. Refer to the following for Edit >> Export Bar and Study Data to File: Edit Menu: Edit >> Export Bar and Study Data to Text File Refer to the following for the Write Bar and Study Data to File study: 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: