Login Page - Create Account

Support Board


Date/Time: Thu, 25 Apr 2024 09:45:51 +0000



Trade Activity Import disappears

View Count: 599

[2021-05-13 22:17:13]
jwick - Posts: 142
I'm having an issue with one of my sub-instances. When I clear the trade activity log and then import trade activity (fill data) from a file, the import seems to go successfully (I see all of the trades in the trade activity window, correct trade stats are displayed etc); however, if I hit the Apply button, all the trades disappear. As well, when I do the initial import, none of my charts display any of the trades (display chart order fills is enabled).

By contrast, if I do the exact same steps in another instance, the trades are successfully imported as before and they remain when I hit the Apply button / successfully appear within the charts.
[2021-05-14 14:20:04]
John - SC Support - Posts: 31098
The first scenario you present makes sense. When you import the data, if the sub-instance is still connected to the primary instance and the primary instance still has those fills, then the sub-instance is going to get that data from the primary instance and will see the imported data as duplicate fills and remove them.

The thing to keep in mind, is that from the perspective of the Sub-Instance, the symbol was not a Simulated symbol, so you would need to change the Symbol filter to All Symbols (Non-Sim) to see those fills listed.

What is more confusing to us, is why you are not having the issue with another sub-instance? Is that other instance a Sub-Instance or is it a completely separate installation? Also, is that other sub-instance (if it is one) connected to the primary instance, in that it is "Connected to the Data Feed"?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-05-14 15:33:49]
jwick - Posts: 142
Oops my apologies I was unclear on two points:
- In both scenarios, I am directly importing trade activity into the respective sub-instance. The primary instance isn't involved.
- In both scenarios, the sub-instance is disconnected from data/trade service (primary instance) the entire time
[2021-05-14 16:46:23]
John - SC Support - Posts: 31098
Just to make sure we understand the scenario.
- Open Sub-Instance.
- Select File >> Disconnect
- Delete Trade Activity information
- Import already exported Trade Activity information
- Fills are not showing properly.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-05-14 21:06:45]
jwick - Posts: 142
Clarification on the last step
- Open Sub-Instance.
- Select File >> Disconnect
- Delete Trade Activity information Trade activity log now empty
- Import already exported Trade Activity information
- Fills display correctly and trade stats calculated accurately in trade activity log (but I suspect internally they have been deleted right after they display in the trade activity log)
- No fills appear on chart. As well, if I hit apply on the trade activity log, that refreshes the log to display no trades (which corresponds to what I'm seeing on the charts showing no trades).


If it helps, I could post a screen recording of what I'm seeing?

EDIT: I did notice another peculiarity. And testing it against three instances, this applied to all of them. In this screenshot the left shows the original trade data generated from a replay. The right shows the imported version of the left. Notice how the prices and trades are imported correctly but the dates / times are wrong: https://i.imgur.com/DAyVnHP.png. Note: In this example, these are two instances that don't exhibit the original problem of trades disappearing after I import them. That seems to be localized to one instance in particular.
Date Time Of Last Edit: 2021-05-14 21:20:00
[2021-05-14 21:42:30]
John - SC Support - Posts: 31098
Are you using the Export or the Save Log As option to save the original Trade Activity Log?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-05-14 21:56:06]
jwick - Posts: 142
ooo I feel you might have hit the nail ... I'm doing a Edit -> Copy All (just faster in my workflow vs manually selecting the save as location each time) and pasting it manually into a file that's in my version control. I'll give Export a try later today and report back. If that does fix it, I'm curious what the difference is (manual copy all / save as vs Export)? Does export do a time conversion (which import assumes was done)? I wonder if this will fix the original issue I was experiencing as well.
Date Time Of Last Edit: 2021-05-14 21:57:16
[2021-05-14 22:01:48]
John - SC Support - Posts: 31098
Yes, there is a time conversion. When you "Export" it converts the time to UTC. The "Import" then expects the UTC time and will make an adjustment to whatever times are seen in the imported file.

But, even though that explains the time issue you are seeing, it does not explain the issue of the fills disappearing. We have tried a few different scenarios, but in every one, things work as expected where the imported data is left in the Trade Activity Log as expected as long as the Sub-Instance is Disconnected.

Can you give us a copy of the file you are using to Import? Attach it to this thread using these instructions:
https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile

There may be an issue with Fill Execution Service ID that may be causing the issue.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-05-15 23:15:06]
jwick - Posts: 142
Attached.

Also, today I noticed that the trade activity log on the subinstance with the issue would not update (query count only increases). Feels like it's related. Here's a screenshot: https://i.imgur.com/9eY80GY.png. No matter how long I gave it, the active queries wouldn't drop. Only happened in that one sub-instance.

EDIT: Not sure what the reason was but it (the query count) eventually (after an hour or so?) cleared up. I'm going to start working with a new-subinstance since as far as I can tell both anomalies are restricted to the single one. Assuming it doesn't crop up again I should be good to go. I'll keep a backup of this original subinstance folder in case it's of any use in troubleshooting.
Date Time Of Last Edit: 2021-05-15 23:21:58
Private File
[2021-05-15 23:54:15]
Sierra Chart Engineering - Posts: 104368
This is explained here:
Trade Activity Log: Trade Activity Not Displaying or Clearing (Improving Trade Activity Query Performance)

There is no anomaly here. There is a very specific reason why this happens.

Also, we do not look at screenshots, on other sites. Those as a matter of policy are ignored.
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
Date Time Of Last Edit: 2021-05-15 23:55:02

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

Login

Login Page - Create Account