Gamestudio Links
Zorro Links
Newest Posts
Data from CSV not parsed correctly
by EternallyCurious. 04/18/24 10:45
StartWeek not working as it should
by Zheka. 04/18/24 10:11
folder management functions
by VoroneTZ. 04/17/24 06:52
lookback setting performance issue
by 7th_zorro. 04/16/24 03:08
zorro 64bit command line support
by 7th_zorro. 04/15/24 09:36
Zorro FIX plugin - Experimental
by flink. 04/14/24 07:48
Zorro FIX plugin - Experimental
by flink. 04/14/24 07:46
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
1 registered members (SBGuy), 652 guests, and 3 spiders.
Key: Admin, Global Mod, Mod
Newest Members
EternallyCurious, howardR, 11honza11, ccorrea, sakolin
19047 Registered Users
Previous Thread
Next Thread
Print Thread
Rating: 3
SPY 1m data #480083
05/19/20 15:46
05/19/20 15:46
Joined: Jul 2017
Posts: 784
Z
Zheka Offline OP
User
Zheka  Offline OP
User
Z

Joined: Jul 2017
Posts: 784
JCL,

while underlying prices in Zorro-provided *.t8 file are correct (and are taken at around 16:00 ET, end of RTH), 1min bars in *.t6 files are not.


Pls have a look at 2 screenshots. One is Zorro-provided *.t8 vs Zorro *.t6 file, and the other is Zorro's *.t6 vs IB's data (which matches underlying prices in the *.t8 file).


For 2020, SPY prices in t8 and t6 files are close, but not for earlier years. Basing strike/ vol calculations on such prices is erroneous.

But even at the end of 2019, when prices in t6 are close to correct, they are shifted by 1min (i.e. reflect start of the bar).

So, what are the prices in *.t6?

Attached Files SPY_1min_vs_t8_19-01-03.JPGSPY_1min_vs_IB_19-12-27.JPG
Re: SPY 1m data [Re: Zheka] #480094
05/20/20 08:11
05/20/20 08:11
Joined: Apr 2008
Posts: 585
Austria
Petra Offline
Support
Petra  Offline
Support

Joined: Apr 2008
Posts: 585
Austria
You are familiar with the difference between adjusted and not adjusted prices?

Re: SPY 1m data [Re: Zheka] #480118
05/21/20 12:23
05/21/20 12:23
Joined: Jul 2017
Posts: 784
Z
Zheka Offline OP
User
Zheka  Offline OP
User
Z

Joined: Jul 2017
Posts: 784
I am, but until today thought that the adjusted prices are "forward adjusted" and represent Total Return to an investor ( and therefore adjusted prices are bigger that non-adjusted, hence my question)

As I found many vendors use "back-adjustment" (similar to continuous futures), with some deducting absolute dividend amount to adjust and some - correctly - ratio-adjust (like Quandl).


Are Zorro-supplied data ratio-adjusted?


Forward adjustment more correctly represents returns and the data do not need to be rerun with each dividend.

https://quant.stackexchange.com/questions/42445/total-returns-from-adjusted-close-prices

Re: SPY 1m data [Re: Zheka] #480119
05/21/20 13:35
05/21/20 13:35
Joined: Jul 2000
Posts: 27,978
Frankfurt
jcl Offline

Chief Engineer
jcl  Offline

Chief Engineer

Joined: Jul 2000
Posts: 27,978
Frankfurt
When you write an options trading system, you should know about adjusted and unadjusted prices because you'll often need both. You can look up on many websites how they are calculated. Basically you multiply the close with a factor (1 - dividend/ex-price). I don't think that companies pay negative dividends, so you can see that adjusted prices are always smaller than unadjusted prices, never bigger.


Moderated by  Petra 

Gamestudio download | chip programmers | Zorro platform | shop | Data Protection Policy

oP group Germany GmbH | Birkenstr. 25-27 | 63549 Ronneburg / Germany | info (at) opgroup.de

Powered by UBB.threads™ PHP Forum Software 7.7.1