Home >> Support Board

Support Board

Date/Time: Sun, 19 May 2024 22:50:38 +0000

How to Post a Message for Support

Account Balance Text Study

View Count: 1312

[2015-05-25 13:52:42] #1 [Go To First Post]
User25311 - Posts: 30
Hello. I trade with Interactive Brokers, and I made a Spreadsheet Study that uses Account Balance Study for its calculations. The problem is that Account Balance Study for Interactive Brokers doesn't use the real account balance data (what I need). It uses the "Cash" parameter, which is different. And when, for example, I open a new leveraged possition, it results on a negative balance. Then the Account Balance Study turns on negative, and my spreadsheet study ceases to be useful. I know my english is bad but I hope you understand. Thank you. Date Time Of Last Edit: 2015-05-25 14:22:14

[2015-05-25 20:41:20] #2 [Go To First Post]
User25311 - Posts: 30
I've been reading about this problem and I understand now the limitations of the Account Balance studies. Hence my question above is resolved. But after this, arises a new related question. If there is a function to display the amount of open trades (of a symbol or the global of the account) in the spreadsheet, I could program a solution to my problem. Does this function exists? Thank you

[2015-05-26 06:15:18] #3 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
If there is a function to display the amount of open trades We need to understand exactly what you are looking for. Do you mean the cash required to maintain all of the Trade Positions in the account? 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

[2015-05-26 07:00:40] #4 [Go To First Post]
User25311 - Posts: 30
No, sorry about my explanation. I want the value of the position (in the currency of the position). F.ex: If I have a opened position of 2 XAUUSD, and last price of XAUUSD is 1200$, 2x1200 = 2400$. I'm looking for a function that displays 2400 (or the symbol of opened positions + quantity of opened positions, it would also be helpful). Thank you very much. Date Time Of Last Edit: 2015-05-26 07:01:10

[2015-05-26 19:43:15] #5 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
You can calculate this yourself just by using the Position Average price or the last trade price and multiplying by the Position Quantity. All the data is available on the spreadsheet already. Unless you want to do this for all symbols which would not be possible in a spreadsheet. 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

[2015-11-19 11:59:54] #6 [Go To First Post]
User25311 - Posts: 30
Hi again! I'm hardly trying to know how to obtain the Position Average price you mentioned, but I can't.. How can I obtain this value for using it on my spreadsheet? Thanks

[2015-11-19 16:18:38] #7 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Are you using the Spreadsheet System for Trading study? 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

[2015-11-19 16:35:36] #8 [Go To First Post]
User25311 - Posts: 30
Spreadsheet Study

[2015-11-19 16:45:40] #9 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
You need to use the study named "Spreadsheet System for Trading" study. You will see the Position Average Price in the J column. 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

[2015-11-19 16:54:27] #10 [Go To First Post]
User25311 - Posts: 30
Yes, but with my package I can't use the Spreadsheet System for trading. Is there any possibility to obtain the "position average price" (or a input of trades) in a cell of the Spreadsheet Study?

[2015-11-21 04:43:05] #11 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
No, there is not a way to do this other than to use that study. We can apply a discount to your account for the next few months and you can change your service package to 3. 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

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