KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums KX Academy Capstone Project Issue | 3. Data Analytics and Reporting Re: Capstone Project Issue | 3. Data Analytics and Reporting

  • venu

    Member
    May 5, 2022 at 12:00 am

    The trade table does not have column called “date”.  I have loaded trade table using the below command.  Please advise if I am missing something.

    `:/dbs/2020.08.03/trade`:/dbs/2020.08.03/trade`:/dbs/2020.08.04/trade`:/dbs/2020.08.05/trade`:/dbs/2020.08.06/trade

     

     

    I have added date field to tradeContext separately using the following code.

    tradeContext:select date:date:2020.08.06+500?1,option_id,trade_id,time ,price,qty,side,edge,exch_id,broker_id,bid,ask from aj[`option_id`time;trade;nbbo]

     

    thanks