Login Page - Create Account

Support Board


Date/Time: Sat, 23 Nov 2024 08:37:43 +0000



First trade last trade in spreadsheets

View Count: 92

[2024-09-08 17:26:56]
bskogz12 - Posts: 38
When looking at futures data via the edit/download-dgta editor, when viewing the emini i see the first trade/last trade under open, is it possible to get this in the spreadsheet?

I have gone down to individual trade and it looks like it does not show up.

Second question if it makes sense...

Also i want to eliminate orders with the quantity of 1, this is easy to do when you group the orders together, but when you split the orders up it cant be done, i want to eliminate orders of 1, not transactions of one
[2024-09-09 14:49:53]
John - SC Support - Posts: 36238
When looking at futures data via the edit/download-dgta editor, when viewing the emini i see the first trade/last trade under open, is it possible to get this in the spreadsheet?

No, this is not available in the spreadsheets.

You can get to this information using a custom study to access the Time and Sales information. Refer to the following:
sc.GetTimeAndSales()

Also i want to eliminate orders with the quantity of 1, this is easy to do when you group the orders together, but when you split the orders up it cant be done, i want to eliminate orders of 1, not transactions of one

To remove orders of a certain quantity, you need to use the volume filtering options in the Chart Settings. Refer to the following:
Chart Settings: Volume Filter (Chart >> Chart Settings >> Data Limiting >> Volume Filter Settings menu)
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