NexusFi: Find Your Edge


Home Menu

 





there may be some data error in TS


Discussion in TradeStation

Updated
    1. trending_up 5,700 views
    2. thumb_up 13 thanks given
    3. group 3 followers
    1. forum 21 posts
    2. attach_file 9 attachments




 
Search this Thread

there may be some data error in TS

  #11 (permalink)
slicent
Taipei City
 
Posts: 15 since Jul 2020
Thanks Given: 10
Thanks Received: 0


SMCJB View Post
Don't know everybody probably does it differently. I do know Trading Technologies push the price well before the 4pm close but they are not your traditional 'bar based trading software'

I think its problem about TS's data feed.
I will change it to more reliable one...

When I try 1440min bar just I found a more data error of TS...and other problems...shock me...
It miss the bar of 7/4(In my time zone the close time of Fri. is 7/4)

2020-07-10 094749

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
What broker to use for trading palladium futures
Commodities
Cheap historycal L1 data for stocks
Stocks and ETFs
Trade idea based off three indicators.
Traders Hideout
About a successful futures trader who didnt know anythin …
Psychology and Money Management
MC PL editor upgrade
MultiCharts
 
  #12 (permalink)
 
SMCJB's Avatar
 SMCJB 
Houston TX
Legendary Market Wizard
 
Experience: Advanced
Platform: TT and Stellar
Broker: Advantage Futures
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,049 since Dec 2013
Thanks Given: 4,388
Thanks Received: 10,207


slicent View Post
When I try 1440min bar just I found a more data error of TS...and other problems...shock me...
It miss the bar of 7/4(In my time zone the close time of Fri. is 7/4)

Most of the data issues I found and reported involved Holidays. Some were real data issues and others were code not processing properly on Holidays.

Reply With Quote
  #13 (permalink)
slicent
Taipei City
 
Posts: 15 since Jul 2020
Thanks Given: 10
Thanks Received: 0



SMCJB View Post
Most of the data issues I found and reported involved Holidays. Some were real data issues and others were code not processing properly on Holidays.

...Last Friday is not a holiday...

Reply With Quote
  #14 (permalink)
 
SMCJB's Avatar
 SMCJB 
Houston TX
Legendary Market Wizard
 
Experience: Advanced
Platform: TT and Stellar
Broker: Advantage Futures
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,049 since Dec 2013
Thanks Given: 4,388
Thanks Received: 10,207


slicent View Post
...Last Friday is not a holiday...

Last Friday, the 3rd of July was a US Holiday. The Holiday is the 4th of July but since that was a Saturday it's celebrated on the Friday.

I don't know what product you trade, but talking about Crude "CL"

NORMALLY
Thu 2nd. 1:28-1:30 Settlement Window.
Thu 2nd. 4pm Last Trade. Start of Maintenance Window.
Thu 2nd. 5pm Reopen. Start of Trading for Fri 3rd.
Fri 3rd. 1:28-1:30 Settlement Window.
Fri 3rd. 4pm Last Trade. Start of Maintenance Window until Sunday.

Sun 5th. 5pm Reopen. Start of Trading for Mon 6th.

LAST WEEK, JULY 4th WEEKEND
Thu 2nd. 1:28-1:30 Settlement Window.
Thu 2nd. 4pm Last Trade. Start of Maintenance Window.
Thu 2nd. 5pm Reopen. Trades done after this point count as trades for Monday 6th since there is no Friday 3rd trade day.
Fri 3rd. 12pm Last Trade. Market Halt until Sunday. No Settlement Window.

Sun 5th. 5pm Reopen. Continuation of Trading for Mon 6th.

So the problem becomes Friday 3rd was officially not a trading day, hence has no high, low, open or close, BUT there was actually trading activity for 19 hours. So theoretically Monday 6th was a 42 hour trading day instead of the normal 23 but the software struggles to handle that. You can understand the underlying reasons why the software struggles with this, but given that this is a billion dollar industry you think they would have worked out how to handle it!

Years ago the market closed on Thursday and didn't reopen to Sunday night. But with the global nature of markets and the shift from exchanges being member/local focused to shareholder/revenue focused this is no longer the case.

Reply With Quote
Thanked by:
  #15 (permalink)
slicent
Taipei City
 
Posts: 15 since Jul 2020
Thanks Given: 10
Thanks Received: 0


SMCJB View Post
Last Friday, the 3rd of July was a US Holiday. The Holiday is the 4th of July but since that was a Saturday it's celebrated on the Friday.

I don't know what product you trade, but talking about Crude "CL"

NORMALLY
Thu 2nd. 1:28-1:30 Settlement Window.
Thu 2nd. 4pm Last Trade. Start of Maintenance Window.
Thu 2nd. 5pm Reopen. Start of Trading for Fri 3rd.
Fri 3rd. 1:28-1:30 Settlement Window.
Fri 3rd. 4pm Last Trade. Start of Maintenance Window until Sunday.

Sun 5th. 5pm Reopen. Start of Trading for Mon 6th.

LAST WEEK, JULY 4th WEEKEND
Thu 2nd. 1:28-1:30 Settlement Window.
Thu 2nd. 4pm Last Trade. Start of Maintenance Window.
Thu 2nd. 5pm Reopen. Trades done after this point count as trades for Monday 6th since there is no Friday 3rd trade day.
Fri 3rd. 12pm Last Trade. Market Halt until Sunday. No Settlement Window.

Sun 5th. 5pm Reopen. Continuation of Trading for Mon 6th.

So the problem becomes Friday 3rd was officially not a trading day, hence has no high, low, open or close, BUT there was actually trading activity for 19 hours. So theoretically Monday 6th was a 42 hour trading day instead of the normal 23 but the software struggles to handle that. You can understand the underlying reasons why the software struggles with this, but given that this is a billion dollar industry you think they would have worked out how to handle it!

Years ago the market closed on Thursday and didn't reopen to Sunday night. But with the global nature of markets and the shift from exchanges being member/local focused to shareholder/revenue focused this is no longer the case.


2020-07-11 123255


2020-07-11 123342


Thank you for solving my doubt.
I found another problem...
It's so odd that the open & high of daily and 1440min of the same day is different....

Reply With Quote
  #16 (permalink)
 
SMCJB's Avatar
 SMCJB 
Houston TX
Legendary Market Wizard
 
Experience: Advanced
Platform: TT and Stellar
Broker: Advantage Futures
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,049 since Dec 2013
Thanks Given: 4,388
Thanks Received: 10,207

@slicent

Smells funny....
@CL
6/21 and 6/22/01 same open high low and close
6/25, 6/26 and 6/27/01 no prices at all!


Reply With Quote
  #17 (permalink)
 
SMCJB's Avatar
 SMCJB 
Houston TX
Legendary Market Wizard
 
Experience: Advanced
Platform: TT and Stellar
Broker: Advantage Futures
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,049 since Dec 2013
Thanks Given: 4,388
Thanks Received: 10,207

And another. Really not difficult to find....


Reply With Quote
  #18 (permalink)
 
SMCJB's Avatar
 SMCJB 
Houston TX
Legendary Market Wizard
 
Experience: Advanced
Platform: TT and Stellar
Broker: Advantage Futures
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,049 since Dec 2013
Thanks Given: 4,388
Thanks Received: 10,207

And another. That's 7 bad data points in a 6 month period.


Reply With Quote
  #19 (permalink)
 
SMCJB's Avatar
 SMCJB 
Houston TX
Legendary Market Wizard
 
Experience: Advanced
Platform: TT and Stellar
Broker: Advantage Futures
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,049 since Dec 2013
Thanks Given: 4,388
Thanks Received: 10,207

Sure you don't want me to post charts of them all but just downloaded 20 years of @CL data and there's 16 obvious data errors all in 2001-2003. Must but not all are associated with US Holidays.

Reply With Quote
  #20 (permalink)
 
SMCJB's Avatar
 SMCJB 
Houston TX
Legendary Market Wizard
 
Experience: Advanced
Platform: TT and Stellar
Broker: Advantage Futures
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,049 since Dec 2013
Thanks Given: 4,388
Thanks Received: 10,207


Last one. I promise....


Reply With Quote
Thanked by:




Last Updated on July 25, 2020


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts