Login Page - Create Account

Support Board


Date/Time: Wed, 19 Mar 2025 01:13:58 +0000



IB information

View Count: 535

[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:

Login

Login Page - Create Account