Traderji.com - Discussion forum for Stocks Commodities & Forex

Loading EOD Derivatives data into Amibroker

Discuss Loading EOD Derivatives data into Amibroker at the AmiBroker within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Trading Gurus, Need some help. I have a updated Amibroker database for NSE Cash data. ...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > TOOLS & RESOURCES > Software > AmiBroker

Notices


Advertise Here

Reply
 
Thread Tools
Sponsored Links
  #1  
Old 11th October 2007, 07:52 AM
Member
 
Join Date: May 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Appreciation: 20
ramakrishnaiah is on a distinguished road
Default Loading EOD Derivatives data into Amibroker

Trading Gurus,

Need some help. I have a updated Amibroker database for NSE Cash data.

But I am getting confused on loading the Derivatives bhav copy into a new database.

Derivatives data contains next 3 months expiry data. put call options etc.. Amibroker import wizard does not provide any columns to load all these data. How do I ensure I have all the relevant data in the database?

Also how do I use it for analysis

1. Does expiry date?, put or call these fields make any difference in TA?

2. Can I apply Cash market TA into Derivatives TA?
Reply With Quote
  #2  
Old 23rd October 2007, 11:06 PM
Member
 
Join Date: Oct 2007
Posts: 104
Thanks: 0
Thanked 6 Times in 2 Posts
Appreciation: 26
Adheer is on a distinguished road
Default Re: Loading EOD Derivatives data into Amibroker

AmiBroker does not support Options parameters like Strike Price, Expiry Date etc therefore you cannot import Options into AmiBroker.

Additionally, performing technical analysis on Options using well-known technical indicators is meaningless since Options will respond differently to price changes of underlying securities.

As for futures, you can import the future quotes "as is", as long each future quote has a unique symbol ( a combination of underlying symbol and expiry). However, once again this is not very useful because the premium / discount of the future instrument changes over time and thus adds more "noise" to the data being considered for technical analysis.

That being said, I import Futures quotes into AmiBroker but I process the Bhavcopy data before importing it into AmiBroker.

I create a "Continuous Futures Contract" (CFC) based on (weighted) volume and open interest of the near month, next month and far month contracts. CFC theoretically has no expiry date and behaves similar to the underlying cash symbol except for premium and discount.
If you are into hedging, spread-trading or arbitrage, CFC can be helpful to uncover the discrepancies in premium / discounts.
For example, a simple method to calculate the CFC of Reliance futures is :

Near Month (Vol x Avg Price ) + Next Month (Vol x Avg Price ) + Far Month ( Vol x Avg Price ) divided by combined volume of the 3 contracts.


There are many other techniques to calculate CFC prices.
http://www.premiumdata.net/support/f...continuous.php
Reply With Quote
  #3  
Old 27th January 2008, 12:16 PM
Member
 
Join Date: Oct 2006
Posts: 228
Thanks: 36
Thanked 23 Times in 18 Posts
Appreciation: 43
musicjunkie is on a distinguished road
Default Re: Loading EOD Derivatives data into Amibroker

Hello Adheer
Is there a programe that can give last 5months on data atleast? an alternative options much appreciated
MJ--
Reply With Quote
Sponsored Links


Reply

Bookmarks


Advertise Here


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


All times are GMT +5.5. The time now is 06:00 AM.

Indemnity, Disclaimer & Disclosure Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum Rules Disclaimer & Disclosure and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © 2001 - 2008, Traderji.com All Rights Reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.MasterOfTrading.com