Hello all I need to create a monthly candelstick chart for the last 20 years of Options Expiration candles, i.e. the close being the third friday of every month instead of the calendar close. Any idea how to do this? J
Not sure your level of sophistication, but if you know R, download, install and use http://www.quantmod.com/.
A popular R package that provides elitetrader-friendly functionalities for those willing to do some coding. > install.packages("quantmod") > require(quantmod) Written and maintained by the estimable Jeff Ryan http://www.lemnica.com/.
OK so I have now familiarized myself with R since I found no other way to do this, but I still can't figure out how to use quantmod to draw the chart I need? Help appreciated J
I am looking to demonstrate that this past options expiration cycle (August 2011) was the worst in the last 15 years. (down 16% NDQ from Monday 7/18 Open to Close Friday 08/19)
And what is the purpose of this demonstration? You are posting in an options forum, how can a 16% NDQ drop be considered "the worst in the last 15 years" for options. No such thing as a bad month for options. For the month of August 2011 I posted a LIVE blog of my QQQ options trades and made a return of +112% . If the market gives you Lemons, make Lemonade. August 2011 QQQ Weekly Option Trades - Final Results --------------------------------- I put the ELITE in EliteTrader