Support Board
Date/Time: Wed, 27 Nov 2024 12:26:47 +0000
[User Discussion] - what do you know/think about Trades/Viz
View Count: 1783
| [2023-06-22 12:14:22] |
| User849502 - Posts: 346 |
|
Hi John, I have been using a very basic Excel sheet to keep trade of my trades. Some guys on OFL have recommended this. As you must have approved it if it can access my SC software. Before I sign up can you just give me an all-clear on them? Don't forget the professional>non-p |
| [2023-06-22 15:24:05] |
| Sierra_Chart Engineering - Posts: 17191 |
|
We are not familiar with this. We will check on the nonprofessional status for you. 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, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-22 15:50:30] |
| SC Support - Posts: 1895 |
|
Hi User849502, I think last time we checked about your Non-Professional / Professional status the hang-up was that you were still a member of the exchange, did you give up that membership? Thank you
|
| [2023-06-22 16:21:15] |
| User849502 - Posts: 346 |
|
it will be done in the next week, as soon as I get a firm confo from CME I will send it. Is that what youwant
|
| [2023-06-22 16:23:44] |
| User849502 - Posts: 346 |
|
John, How can a firm link to your software without you knowing about it? That's not good. Maybe you should google them and contact them. |
 tradeviz.PNG / V - Attached On 2023-06-22 16:23:39 UTC - Size: 440.65 KB - 182 views |
| [2023-06-22 18:43:10] |
| SC Support - Posts: 1895 |
|
Regarding "Trades/Viz to keep trade of my trades", we are not familiar with them and don't know what access / permissions we need to provide for them (Trades/Viz). You can access your Trades via the Trade Activity Log [Trade >> Trade Activity Log] and export them from there. Trade Activity Log: Importing and Exporting Data |
| [2023-08-08 21:32:51] |
| User61168 - Posts: 403 |
|
Hi John, I also came across TradesViz via Google today and per my preliminary research, they have robust features to compliment trade activity log. I am also quite surprised SC is not aware of this provider as they work with brokers and platform owners and allow realtime autosync capabilities to transfer trading activity from SC directly into their platform. I was hoping to get your blessing before I sign up as they need account information etc and don't feel comfortable unless they are 'certified' by Sierra Chart. It appears they have a study developed that does the autosync so it should be quite easy to look at their solution and certify the use of such vendor (from a security and privacy standpoint). Regarding trade activity log, I will share my biggest frustration with the inability of such a advanced and professional grade platform to track max account equity at the intra day/week/monthly level. The Equity Peak column under Period Stats shows a inaccurate/misleading picture of strategies that involve taking profits only at session close... meaning, if I have a intra-day peak PnL of 100points closing down at breakeven, it does not reflect peak equity of 100points. Huge limitation imo! It should reflect true "peak" acount equity on a daily/weekly/monthly basis. This is the only reason why I want to move to a 3rd party solution. Access to accurate accounting of peak intra-day/week/month account equity in real time is of paramount importance to algorithmic trading proactive drawdown management :-( Edit: Here's the link to their autosync setup: https://www.tradesviz.com/blog/auto-import-sierrachart/ Date Time Of Last Edit: 2023-08-08 21:38:27
|
| [2023-08-09 12:36:15] |
| SC Support - Posts: 1895 |
|
We'll look into this. Thank you
|
| [2023-08-10 00:17:11] |
| JohnR - User831573 - Posts: 306 |
|
All, This is just for info, I am not associated in any way with this product. There is a pretty good Excel based Trade Journal. Trade-Journal-Spreadsheet. I am fairly new to it, but it has many, many ways to analyze your trades. Downside, is it does not have a link to download the data from SC or from your broker. The amount of fields they have to be part of your trade is extensive, so importing would only get you the basics of a trade. One of the things that is important to me is that I can keep the data on my system vs on yet another vendors cloud. Plus, it is a one time purchase, which I also prefer. Your milage may vary, JohnR |
| [2023-08-10 01:08:17] |
| SC Support - Posts: 1895 |
|
Thank you JohnR
|
| [2023-08-10 01:38:26] |
| User61168 - Posts: 403 |
|
Thanks JohnR. Could you please describe how cumbersome is the manual import process from SC's trade log in to TJS. Does it support the calculation of real account peak equity on a daily/weekly/monthly basis as described in my post #7? |
| [2023-08-10 02:42:39] |
| JohnR - User831573 - Posts: 306 |
|
Hey User61168, It is my first 'digging into' - using TJS (Trade-Journal-Spreadsheet). It does seem very capable in its rubik's cube-like rotating abilities of the data. Here are my thoughts on connecting SierraChart (SC) to TJS with some level of automation. I do realize the value of manually entering the trans info, it's so that me - the user - gets the real value of the program's abilities if it has the data. But that being said -- Being able to avoid mistakes and to save some time, some kind of connection to get the basic 'available' info from SC - Trade Activity Log "Fill" record into a TJS transaction. What I am thinking of, but I have not started, is to use AHK - AutoHotKey, which I use for other things, and have it to some level of semi automated way to get the records via SC - 'Copy All' to get those records - then put them in an existing / open Excel SS. Then copy each column to the appropriate column in your TJS. Then I can go into each new TJS record and update the additional info about each trade. I have 2 coding things & the usual life/family stuff ahead of this would be project. But one could do these steps manually. I have done this at a test of the logic. Select copy All from SC menu, then copy into temp SS. Then select columns of data multiple times to get all fields in temp SS to TJS, and find where they go, It seems to beat rekeying, saves on a lot of possible errors. Since there are soo many columns to match up and get copies, that is where the automation of a macro program would come in handy. Hope this helps, JohnR Date Time Of Last Edit: 2023-08-10 02:46:14
|
| [2023-08-10 02:55:09] |
| JohnR - User831573 - Posts: 306 |
|
I forgot to mention to be sure to be on 'TRADE' tab within Trace Activity Log, then do Copy All Hope this helps JohnR |
| [2023-08-10 05:26:03] |
| User61168 - Posts: 403 |
|
Thanks JohnR. I am pretty sure this excel trade log will not support the calculations related to High/Low equity watermark on a daily/weekly/monthly time duration as it requires access to tick level data to do the calculations. Reading this thread>> Live equity peak & valley calculation : add Low While Open & High While Open datetime , even ASCIL does not support this capability which makes me wonder how algo traders of SC are able to proactively manage drawdowns as part of risk management. |
| [2023-08-10 13:08:19] |
| JohnR - User831573 - Posts: 306 |
|
Thanks JohnR. I am pretty sure this excel trade log will not support the calculations related to High/Low equity watermark on a daily/weekly/monthly time duration as it requires access to tick level data to do the calculations.
in my reading on the TJS site, I think it states it does not connect to any data. which makes me wonder how algo traders of SC are able to proactively manage drawdowns as part of risk management.
I am not there, but what do you mean by proactively manage? Not being a fully implemented Algo setup - I would think you do analysis on your max drawdown on wins and same on losses, then make adjustments to stop-trail-exit parameters then replay / backtest to see if adjustments improve what you are looking for. Heck, rethinking Entry reasons is also a way to eliminate some bad trades. Many of mine are when I go 'off-script'. Gotta love good ole Fear & Greed. I'm working on getting more Algo to make trading more rational and less emotional. Just my thoughts, JohnR |
| [2023-08-10 19:39:43] |
| User61168 - Posts: 403 |
|
In order for algos to be more rational and less emotional , it needs to actively participate in handling of risk parameters to prevent drawdowns, margin calls, consecutive losses etc. without manual intervention. All such techniques require access to account equity in real time (account equity = realized PnL plus floating pnl from open trades). If I want to achieve a MaxDD of 10% and if I have approached realized loss of 8% of account value and I have a running float profit of say 25%, wouldn't I want to proactively sell my open float profit to reduce my realized loss drawdown from 8% to 0% and let the remaining float profit run longer? Having access to High watermark i.e. peak equity of closed and open trades is absolutely crucial. It is the key ingredient of developing strategies with positive expectancy. ProTip: When developing a new strategy, start off with only stoploss and Breakeven trade exits and no profit taking exits. Results will scream at you whether your entry signal i.e. trade frequency is worth pursing. Calculating high watermark on a daily basis (realized pnl plus floating pnl) with such approach will reveal the most important element of intra-day algo trading >> when to exit your floating profits in the most profit-optimized manner to trigger close-all and stop trading for the day! All my algo have take-profit exits only when 1) account is above my maxdrawdown threshold and 2) Close-all when daily profit target is met (and ofc, max loss for the day). For this very reason, I opt to run one algo on one instrument per account. Hope this helps. John@SC Support - The easiest way I can think of is to alter the trading profit/loss text study to output the results in subgraphs that can be accessed in simple alerts. This study already has the code developed to display "Include Open Profit/Loss in Daily Profit/Loss", "Show Maximum Open Position Profit" and "Show Maximum Open Position loss" values so it is just a matter of using these 3 values to calculate High/low watermark and making them available for use in algo trading. Date Time Of Last Edit: 2023-08-10 19:42:43
|
| [2023-08-10 22:49:21] |
| JohnR - User831573 - Posts: 306 |
|
User61168 Thanks for your insights. Any time, anyone is willing to share / pass on knowledge -- Thank you. JohnR |
To post a message in this thread, you need to log in with your Sierra Chart account: