Best used with an AI agent

40+ live apps, open data APIs, MCP servers, and 200+ guides - more than anyone wants to click through. Point your AI here and it reads the whole map and does the work: finds the tool, pulls the data, runs the analysis, and hands you the links.

Here for the open-source code? Your agent finds the right repo for you - and can even clone and deploy it.

Prefer to explore on your own? Go right ahead.

Paste this to Claude Code, Codex, or any AI agent:
Go to tigzig.com and read tigzig.com/llms.txt. It is a practitioner toolkit - 40+ analytics apps, open no-auth data APIs, MCP servers, open-source repos (github.com/amararun), and 200+ build guides. Help me [your task]. Surface the exact links; where there is an API or MCP, call it directly; and if I want to self-host, find the repo and help me deploy it.

Claude in Excel - Nifty50 Return Distribution Analysis (30 days forward) 2008 to 2026

Published: February 8, 2026

Claude Nifty50 Analysis

Exploits of Claude in Excel - xgboost model, live RBI dashboard and now Live Nifty50 - return distribution analysis (30 days forward) from 2008 to 2026.

Here's the analysis - with all the raw data also.

I had last run this analysis quite some time back during my full time trading days as a derivative trader. Had taken me quite some time to setup this analysis. Now - probably an hour of wall clock time doing on the side.

What it does

This is Nifty50 data from 2008 to 2026. After having it run a diagnostics report for sanity check, asked to compute like so:

How it went

It did take around 15-20 minutes of brainstorming with Claude, and had to give detailed instructions but once the instructions were clear, it pretty much got it in one shot. Also asked to prepare a 'manual validation' for a single day. All the formatting and column sizing it did on its own. It's pretty much ready to consume.

Had also asked it to output its code. Keep in mind it runs code iteratively in sandbox, so this is a reconstructed code and not the actual code patches.

Caveat

Prima-facie looks fine. But this one is for live use, so, would be going line by line and replicating via other means and do another tally. Will re-publish the full analysis and insights as it involves a few more pieces.