KX Community

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

Home Forums KX Academy Fundamental Capstone Exercise 3

  • Fundamental Capstone Exercise 3

    Posted by Gerald on January 20, 2025 at 6:23 pm

    I’m just starting the 3rd exercise in the Fundamental Capstone. 
    It first says to create a new table, tradeContext, which should have the same columns as the trade table, but filtered on the last date and contain 2 extra columns.

    But when I look at my trade table (and at the datacreation.q code that creates the trade table), it doesn’t include a date column. I only see these columns in my trade table:

    `trade_id`option_id`time`price`qty`side`edge`exch_id`broker_id

    Any suggestions?

    • This discussion was modified 1 day, 19 hours ago by  Gerald.
    • This discussion was modified 1 day, 19 hours ago by  Gerald.
    megan_mcp replied 1 day, 3 hours ago 2 Members · 1 Reply
  • 1 Reply
  • megan_mcp

    Administrator
    January 21, 2025 at 10:20 am

    Hi Gerald, 

    If you take a look at the Process tab at the top of the workspace, it will show you the tables that have been created. If you expand the trade table, there should be a date column? Also if you run trade in the scratchpad, a data column should be present.

    Let if know if this is different for you and I can check it out.

    Many thanks,

    Megan 

Log in to reply.