Support Board
Date/Time: Wed, 25 Dec 2024 07:01:39 +0000
Account Balance Text Study
View Count: 1371
| [2015-05-25 13:52:42] |
| User25311 - Posts: 32 |
|
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] |
| User25311 - Posts: 32 |
|
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] |
| |
|
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] |
| User25311 - Posts: 32 |
|
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] |
| |
|
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] |
| User25311 - Posts: 32 |
|
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] |
| |
|
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] |
| User25311 - Posts: 32 |
|
Spreadsheet Study
|
| [2015-11-19 16:45:40] |
| |
|
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] |
| User25311 - Posts: 32 |
|
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] |
| |
|
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: