Planilha de Gestão de Banca Trader Esportivo












A spreadsheet for bankroll management in trading should be the first thing a beginner trader should get.

How will we know where we are going without knowing how we are doing?

How so, my dear?

It’s impossible.

Unless you are a myth. And we are not (not yet).

So, nothing is more necessary than having a good record spreadsheet for our bets.

I have posted several here on PedroBet.com and you probably have already downloaded one from here.

But today, I found a new spreadsheet that is very good, so I need to write about this topic again — even though it’s starting to get a bit repetitive.

The spreadsheet I am talking about today is from the TraderFut website and I really liked it.

And I’ll explain why.

It is very simple, yet very functional.

When you open the spreadsheet, the following fields appear:

  • Current Bankroll
  • Profit $
  • Average Profit %

Below that, there is a chart (which didn’t work on my PC because Excel is old).

From this screen, you just need to click on “INSERT DATA” — which is located on the top right of it.

That’s when the real magic happens.

( Click to enlarge // One day I’ll buy the Excel license… until then… patience )

You start by entering your initial bankroll in the “INITIAL BANKROLL” field.

Then, in the editable part of the spreadsheet, you will have the following options for editing:

  • Day
  • Game
  • Market
  • Stake
  • Odds
  • Greens/Reds
  • Stake
  • Bankroll
  • Accumulated
When you click to enter data in the “MARKET” cell, you will be presented with all the markets on Betfair.

With each update, you will see on the right side of the bankroll management spreadsheet where you have more reds and more greens.

This is handy to possibly stop entering markets where you only have reds in the near future and focus on 30 days in markets where you have greens (or 60 or 90 or 120 days, then you can choose the time period better).

Anyway.

To download it, just click on this link —> Click here to download spreadsheet

The download will start immediately and you can start recording all your trading and/or trading days and finally know where the profit and loss from bets come from.

Got it, my dear?

Good greens to those who deserve it.

Best regards,
PJ Pires

.
.
.