[amibroker] Reference Table and Lookup

 

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: tavenui@googlemail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!

**** 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