Telegram Tipster Performance Dashboard

I will send you a bet-by-bet breakdown covering about ten Telegram tipster channels. From that raw feed I need a single Excel workbook that lets me see, at a glance and in depth, how each service is actually doing.

Workbook structure
• One worksheet per tipster, fully cleaned and labelled so I can follow every stake, odds line, result and settled profit.
• A consolidated comparison sheet that pulls all groups together, flags the strongest and weakest using conditional-formatting heat maps, and lets me slice the data quickly with pivot tables.

Key metrics to calculate on every individual sheet and in the roll-up view:
– Average hit rate
– Yield %
– Total profit / loss

Please keep all formulas transparent and traceable; I should be able to audit any cell back to the original bet entry. When everything is in place, lock the file (except the data input range) so nothing can be overwritten by accident.

Once the workbook is clean, referenced and protected, the project is done.

See the file attached and make sure you can join and download data from telegram groups. They are in Italian language.