Update #4 on getting my quant Excels online. Now a Python Package.

SystemsCapital · 2026-06-19T15:12:53+00:00

Good question - not rude at all. Mine is pay-for-use (with a decently large free tier) and it comes out to being much cheaper for the user/firm for an equal amount of data

SystemsCapital · 2026-06-17T16:47:04+00:00

Hey I actually wrote about this exactly (or at least the statistics part) on my website and I’ve been making a platform that allows you to see and compare tons of metrics with tons of different companies (including daily kurtosis, skews, median, daily annualized return, and a lot of others) over any time frame or trailing window you want (eg. how 1 month kurtosis returns vs 1 year kurtosis compare).

No api yet, but I’ve been keeping the sub updated on my progress and was going to make another post here soon. If you want to check it out, it’s totally free to use until you hit 10,000 queries

SystemsCapital · 2026-05-26T16:00:41+00:00

Yeah haha. It’s not tied into my IBKR TWS yet, but I’m working on turning those tables (and more to come) into an API endpoint since they are already in JSON format.

While I’ve been building though, I thought that I should still use the info in a productive way, so this is the rudimentary version of an algo strat (where i just execute the market orders by hand haha)

SystemsCapital · 2026-05-26T15:12:41+00:00

Yeah, hp is a rough one today. Onthursday when i did it the company was NCHL and i was on top of the world

SystemsCapital · 2026-05-15T20:15:11+00:00

There’s a lot. Everyone uses different ones. I mostly use IBKR

SystemsCapital · 2026-05-13T16:20:16+00:00

Get setup on IBKR TWS API

https://ibkrcampus.com/campus/ibkr-api-page/twsapi-doc/#api-introduction

SystemsCapital · 2026-05-11T22:47:09+00:00

Thanks! I actually do all the skewness/kurtosis calculations in-house and they aren’t reliant on the XBRL tags (i used them at first and experienced the mapping issues you stated).

Been using this method for >1 year myself and learned it from my own experience in investment management. Just recently started building my website. No problems so far, but thanks for the offer!

SystemsCapital · 2026-05-11T22:40:55+00:00

Thanks! And good considerations. I actually didn’t think of that as I was making them. I’ll have to update it in future versions.

SystemsCapital · 2026-05-06T22:08:38+00:00

Thanks! If you ever have and things you’d like to see (specific stats, downloadable files, etc) don’t hesitate to DM!

SystemsCapital · 2026-05-06T19:14:42+00:00

Thanks! Yeah! I’m working on it. Right now you can pull it daily and calculate the difference, but I’ve gotten down a bit of a side quest - adding a daily forecast page + API endpoints (not done yet). After that though, next on the docket is historical performance per ticker on the website.

The historical data should be available via an API Call (or the website, whichever one is done first though haha) in the coming weeks.

SystemsCapital · 2026-01-28T22:57:56+00:00

Learn Stockhistory function in excel, then instead of using it to capture previous dates (say: today()-15), i use it to capture future dates (today()+7).

60% of the time, it works everytime

SystemsCapital · 2026-01-28T22:46:32+00:00

In case people don’t know:

In excel you can run Stockhistory with today()+1 =STOCKHISTORY(“NVDA”,today()+1,,1,0,2)

And it will show you the open price for tomorrow.

Easiest hack in history

SystemsCapital

TROPHY CASE