Re: [amibroker] Reference Table and Lookup

 

I.e. create MS Access data base and use AB ODBC AFL plugin for calling Access db.


 tavenui@googlemail.com [amibroker] wrote:
 

I would like to import a csv reference table with the following Columns.

BusDate Market ASXCode Underlying OptType ExpDate Strike Style ContractSize DerivativeProduct ProductType 10/02/2016 ASX AGLLP8 AGL C 25/02/2016 13.75 A 100 AGL OS 10/02/2016 ASX AGLLQ8 AGL P 25/02/2016 13.75 A 100 AGL OS 10/02/2016 ASX AGLLL8 AGL C 25/02/2016 14 A 100 AGL OS 10/02/2016 ASX AGLLM8 AGL P 25/02/2016 14 A 100 AGL OS

Then I would like to lookup the Table and Match the row based on Underlying/OptType/Strike/ExpiryDate.


Any ideas as to how I could achieve this?


Regards


Paul


__._,_.___

Posted by: fxshrat <fxshrat@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/


.

__,_._,___


EmoticonEmoticon