TheTank

Joined 7 years ago

Karma
73
Submissions
38
Member since
Aug 6
www.questdb.io
View on Hacker News

Recent submissions

Comment · 2 years ago
Hey of course, happy to meet and exchange about our fun projects. You can send me an email using the address in the above comment and we'll setup something!
Comment · 2 years ago
Hey, yes I can do that. I will brush this up, package all the bits (3d files, pcb files, code etc), and add to github.

On another note, would you happen to live in London? If you really want to try this I could hand you one which will save you plenty of time finding the parts, printing the case, ordering PCBs, and soldering. You can reach me on first_name dot last_name hat gmail dot come. The name is at the top of the original post.

Comment · 2 years ago
Comment · 2 years ago
Comment · 2 years ago
It's a tough question because most of what I learned was on the job and I don't really remember books specifically on the topic. It also depends on what product and market you are trading, and on what channels (on exchange, over the counter etc.)

I would say it starts with knowing the product you trade and their dynamics inside out. How to make a price for it, what dynamics can change that price etc. It's also a good idea to understand related instruments as typically you would use them for price formation and hedging [1][2].

The second bit is to understand electronic trading infrastructure and the market microstructure such as how orderbooks work, and some trading algos [3]

If you're also interested in the infrastructure behind related to low latency, you can read about FPGAs, Exchange co-location etc. There is a fascinating blog on the network infrastructure [4] and the author (Alexandre Laumonier) also wrote a few books on that topic.

A lot of market-making is bespoke and proprietary. For example your pricing model, hedging model, etc. It's also constantly changing depending on events (e.g. the elections) or market conditions (correlations changing). But a good place to start is to use some simple pricing model such as making a blend of other prices in other venues, or for derivatives making up the price based on the underlying price and other elements which vary depending on what the derivative is.

While you would not be able to gain direct market access to, say, the NYSE, a lot of crypto platforms offer APIs for users to build trading bots as a training ground. For example Bitmex, or Deribit. But before doing this I recommend understanding the contract mechanics inside out. For example, the perpetual futures have a very particular mechanism which means they are priced and traded differently than normal futures you'd read about in the Hull book.

I have a few friends who built bots and make small markets on random cryptos for fun. In this particular case, you'd have to think a bit harder on how you hedge your positions (e.g. can you sell an illiquid coin and hedge with a liquid one for cheap?). One way of doing this may be to look at correlations between coins to find the best hedge. Another consideration for crypto is the fee structure which you'd need to account for in your price.

I don't know if it's a good idea to start doing this in crypto besides for fun though, mostly because it's a business that requires scale to derive a meaningful profit. But as an exercise it's definitely fun.

[1]Options, Futures, and Other Derivatives (J. Hull)

[2]The handbook of fixed income securities (Frank J. Fabozzi, Mc Graw-Hill Gb)

[3]Algorithmic Trading & DMA (B. Johnson)

[4]https://sniperinmahwah.wordpress.com/

Comment · 2 years ago
Comment · 2 years ago
They did continue participating but it's true that this became a sort of electric train where daddy buys it for the children and ends up playing the most with it.

The trading game did not capture their interest further than watching colourful flashes for a few minutes. It's probably too complicated for their age and hard to understand without knowing some basic financial markets knowledge.

However I used the same device to make other more appropriate games and keep them involved. I could ask them what game they would want, and I would make most of it but involve them in the parts of the code that can be meaningful to them. I found that while they like understanding how it works when I walk them through some small bits of code, writing code (even heavily assisted) is still daunting at their age so they prefer tools like MIT scratch.

Comment · 2 years ago
You're right and besides that, it's not an interesting game for them. I continued involving him using the same platform, but we made more age-appropriate games. It's easy to upload a different game over a USB cable so I could just remove the trading one and upload some other.

Some of the games we made were a quizz platform (times tables, French words etc.), a version of etch-a-sketch where they can move a cursor around, draw, and change the color, and a 2d space shooter game.

It was a good platform to introduce them to code on some of the more tangible bits such as explaining that the screen is a grid of pixels, and that hitting the move button means incrementing your position variable by a few pixels. It's also quite cool for them to be able to bring this to school and to explain how it works, both from an electrical standpoint, and for some of the simple software bits.

Comment · 2 years ago
Author here. Thanks for reading this post. I had fun making this and thought the path that led me to this might be interesting for others.

I’m really interested in feedback and ideas on things I could improve and add. I found this really inspiring as it got me more into programming, discovering electronics, and 3d printing.

I have no desire to ever make this project commercial, but it’s been a great platform for me to learn and experiment new things so I’ll take any idea be it for the gameplay or purely technical. Some features I have in mind are:

- Multiplayer over bluetooth where one device is the ‘game-master’ running the exchange and can monitor and guide players while injecting events.

- Additional quoting algos such as pegging one side of the order book and fighting for position

- A tutorial and better UI. The game is hard to pick up for the first time and probably needs to be made more intuitive etc.

While all of this was made with no practical use in mind (there are a lot of markets and products, and you’d trade them in different ways, so you’d need a different game to speak to a volatility trader for example), some people I work with at various trading desks found it useful for interviews or as an introduction to the idea of market-making for junior people.

Comment · 6 years ago
Author here. You are right this is convoluted and confusing.

I wanted to write an informal introduction to options using a more tangible example for those who are put off by the maths but still would like to gain an intuitive understanding. At the same time I wanted to show things I found were interesting in the data.

It may have been better to separate the two ideas. As you rightly say, one is confusing the other in the current form.

Comment · 6 years ago
Congrats on launching. It looks like it’s only email login. Do you have an idea when you will release Oauth logins?
Comment · 6 years ago
Thanks! Indeed we are still light on available aggregations. Right now we are focused on building a fast infrastructure to support them, for example Swissmap / "rosti" for keyed aggregations. Next steps will include multi-pass algorithms. Once the infrastructure is done (and fast), adding functions will be much easier.
Comment · 6 years ago
Comment · 6 years ago
The trips table takes 313GB. QuestDB is not an in-memory DB. The data sits on SSD EBS volumes.
Comment · 6 years ago
Tanks for the feedback.

WHERE queries are slow indeed. This is not because of the load but rather because WHERE clauses are not yet implemented under the fast path. Currently they run under an old model which is single-threaded which is why they are painfully slow.

We will make these as fast as the rest soon.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton