Spreadsheet layout

Here we have an example of filled spreadsheet with all required information. Most of the spreadsheet is updated automatically by the tool and a big part of spreadsheet can be filled with one click of a button. Let's explain the main columns briefly:

• Date - Date and time when the notification came

• Notification - Notification name which is added when the notification is being created.

• Country - Shows the country or region name where the game was played.

• League - Shows the league where the game was played.

• Time - Game time at the point when the notification was sent out.

• Game - Home and away team.

• Odds - Odds on the selected market at the time when the notification was sent out. You can select the market when creating a notification, the next step after the game time settings, named QUICK ODDS.

• Market - Goal line, asian handicap, 1x2 etc. To fill this, just click on the correct odds in ODDS section and tool will fill this automatically.

• Submarket - Is also filled by the tool automatically when clicking on correct odds and market on ODDS section. Over 2.5, over 3.25, - 1 asian etc.

• Score - Scoreline at the time when the notification was sent out.

• Final Score - As the name says, game final score.

• Odds - Odds available for betting when the notification came on the market chosen in the notification. Also filled automatically by the tool when clicking on ODDS section.

• Stake - Filled manually by the user.

• Result - Filled manually by the user. Dropdown menu opens when clicking on Result.

• Profit/Loss - Calculated automatically by the tool when all the previous boxes are filled.

Spreadsheet top and bottom information

On top of the spreadsheet we can see 3 different numbers:

• Total staked - Total amount staked per this particular page. 
• Total profit - Total profit or loss per this particular page.
• Yield - Total yield of resulted games per this particular page.

Keep in mind, that these numbers are calculated only per page. You can move to another page of notifications at the bottom of the spreadsheet, right side.

Default stake - You can use the default stake function by entering the stake in the first panel and click Fill empty fields. In order to Save this, you need to Result the games first and only then the Save function will remember all the info you updated. 

On the bottom of the spreadsheet, you can do 2 actions. From the left side, you can choose how many games will be shown per one page from 50 to 500. On the right side, you can move from one page to another, depends on how many notifications and pages are available for you.

Notification, Country and League filters

In order to get the most out of the spreadsheet, we added a plethora of filters for our users.

Let's start from the first filter!

Notification filter:
Activate filter by clicking on the Notification tab. A new window opens and you can move it around the spreadsheet, change its size and stretch it however you prefer.
Notification filter has all the active notifications names, which you can activate or deactivate at any time. When unclicking a notification, spreadsheet removes this notification games. You can activate the notification and add the games back into the spreadsheet by clicking on it again.
This makes it easier to check the results of different filters one by one for example. I can remove 3 notifications and check the results of only the first filter. Then I can remove the first, third and fourth and check only games for the second filter etc.

Country filter:
Acts similar to the previous filter. Best to use when you have all the games resulted, as the tool shows and calculates automatically either profit or loss you have with these countries with selected notifications. It’s easier to spot profitable countries for these notifications and exclude them in the future from the notification (from manage notification) in order to make profitable ones.

League filter:
Similar to Country filter. Click on the main tab and new window opens. The tool shows the profit/loss count with the exact amount of either profit or loss with the notifications count. This helps to spot the leagues which are profitable during the given time period with particular notifications. By eliminating the leagues where this notification doesn't bring profit, you can turn your luck around and create a profitable customizable notification for years to come!

P stands for profit/loss count and C stands for the number of games you have with this notification in this league or country!

Score, Odds and Stake filter

Why I have added these 3 in the same place is simple, all of them are range filters! Score and odds analyze can give you more information compared with stake filter.
Score - Essential filter in order to analyze if the notification has better results if the scoreline is 0-0 or there has already been a goal in the game. Teams can play for at least a draw if there's not much playing time left. The game should be much more open when one team is leading already. Also gives a great angle for analyzing the outcome if there's already a big lead for one team.
Odds - The better the odds, the higher your profits are on this game. With odds range filter, we can check if we are better when playing on higher or lower odds. Lower odds, of course, mean smaller profits per game. But maybe the hit rate is big enough on lower odds to gain meaningful profits for some notifications. Let's analyze!
Stake - Punters can rate some notifications too high and vice-versa. Stake range filter can give us a clear indication on whether we should use smaller stakes on some notifications or raise the stakes a little with lower odds notifications.

Result and Profit/Loss filter

Result and Profit/Loss filters are the last ones on the spreadsheet, but as important as previous filters. Using the Result filter or Profit/Loss range can be used
for detecting the leagues or countries where your notification in the given time period range hasn't been so successful.
For example, remove win and half win results from the filter and you can see quickly the leagues and countries which are letting you down!