2023.03.02 05:52 PM
There are some trades done before any quotes. So when using aj I get some empty values for the columns bid and ask.
2023.03.05 02:39 PM
Hi @PhilSing24,
Thanks for raising.
In the real world there should be quotes before trades. I assume given this is an exercise, the data has been randomly generated across a time period and hence you are seeing the above.
I wouldn't be too concerned, as long as you can see how aj works with some other option_id that's what matters.
2023.03.05 02:39 PM
Hi @PhilSing24,
Thanks for raising.
In the real world there should be quotes before trades. I assume given this is an exercise, the data has been randomly generated across a time period and hence you are seeing the above.
I wouldn't be too concerned, as long as you can see how aj works with some other option_id that's what matters.
2023.03.13 11:24 AM
Phil you are so far ahead, mate!
Let's start with loading in our newly created partitioned database which was created at getenv[
HOME],"/fundamentals_capstone_dbs/"`.
1.1 Load into the current process the database that was created
I tried this command without success:
\l $HOME/fundamentals_capstone_dbs/
\l ./db/fundamentals_capstone_dbs/
As part of the initialization we created a partitioned database with the following tables:
1. `trade` - contains all the trade details
2. `spread` - Contains the option spread definitions
3. `nbbo` - Contains the National Best Bid Offer quotes for each option
None of these tables have been created after loading the data so I guess my commad for loading the data has some error.
But where?
Thank you so so much for reaching out to me.
I have poted my question in the community as well.
Gratefully,
Angelica
PS I work for a consultancy firm and some of my colleagues want to learn qdb+. I am supposed to inspire them and I get stuck so so easily. Not even chatgpt could help me!
2023.07.12 04:16 PM
You can use either of below commands
\l ${HOME}/fundamentals_capstone_dbs
or
system"l ",getenv[`HOME],"/fundamentals_capstone_dbs/"
EMEA
Tel: +44 (0)28 3025 2242
AMERICAS
Tel: +1 (212) 447 6700
APAC
Tel: +61 (0)2 9236 5700
KX. All Rights Reserved.
KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.