cashier:games:horses-field-sheets [Aardvark Technologies Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Horses Field Sheets ======

===== Overview =====
Field sheet is a report that provides the ability to see liability that each horse is holding. Additionally, the report displays current and average odds, total stake that was bet on the horse, potential win and the total count of the bets made. It is essentially a tool for risk managers to manage risk effectively - monitor active races, evaluate betting trends and make further decisions to minimize their potential liability, if needed. In this case, field sheets can be generated for both **active** and **finished** events.

===== Admin Interface =====
To generate a certain field sheet, the user needs to use the **Filter** section to filter out and find the concrete needed race. 

**Components of a typical field sheet Filter section:**
  * **Date** filter section. Events can be filtered out by entering a custom date range or choosing one of default date filters (e.g. //Today//, //Tomorrow//, //Yesterday//, etc.);
  * **State** filter section. Events can be filtered out by their current state: //Active//, //Finished//, //Killed// (multiple choice can be made);
  * button **Load Events** to generate events list by selected filters;
  * filtered events list;
  * **Auto Refresh** option, where custom time can be set up for reports to refresh liability data for event that is already selected.
{{ :cashier:games:image2.png?600 |}}

**Components of a typical field sheet:**
  * selected race country, stadium, number and date;
  * race status (active/inactive);
  * race closing time;
  * total stakes per market sum (list of all markets and their total stakes can be displayed when **Show all** is clicked). The total stake sum is clickable - it redirects to the bet legs report and displays all of the bet legs containing bets on chosen market);
  * option to display SP/Fixed or Openbets field sheet;
  * main data about horses of chosen event (odds, stake, potential win, liability, bet count).
{{ :cashier:games:image14.png?600 |}}

===== Field sheets for active events =====
Field sheets reports for active events include and continuously update data and liability calculation with all bets made until the event bet close time. 

**Important:** for data to update automatically, //Auto Refresh// option should be turned on:
{{ :cashier:games:autorefresh.png?600 |}}

=== Single bet ===
For example, a user is placing a single bet on a **Fixed Win** market, where odds are equal to **6.0**, and the stake for a bet is **5.0 Eur**. 
{{ :cashier:games:singebetfield.png?300 |}}
The horse data, at field sheets report, on which the bet was made, updates correspondingly to the bet. 

When a horse accumulates bets, its name becomes clickable. Clicking on it redirects to the bet legs report, displaying all bets made on that horse:
{{ :cashier:games:image6.gif?800 |}}

**Calculations for the Win Market are made accordingly:**
  - **Win Stake** of a horse is equal to the total stake that was betted on the horse at this specific event (//at the example below the total bet stake for a horse was 5 Eur//).
  - **Potential win** of a horse is calculated by adding up all of the possible winnings of each bet that was made for it.
  - **Liability** = Total Win Stake - Potential Win. (//e.g. 5 - 30 = -25//. This means that if the concrete horse would win, the bettor would lose 25 Eur.)

**Important:** For a fixed place market, the total sum of liability is divided by the number of Each Way (EW) Places for more accurate data.
{{ :cashier:games:singlefieldsheets.png?800 |}}
{{ :cashier:games:image8.gif?800 |}}

=== Multibet and System bet ===
For example, a user is placing a multibet on **Fixed Win** markets, where the odds for the first bet leg are **11.00** and for the second bet leg are **10.00**, with a total stake of **5.0 Eur**.
{{ :cashier:games:multifield.png?300 |}}
**Calculations for the first event in the multibet bet slip (Win Market) are made accordingly:**
  - **Win Stake** of a horse is equal to the total stake that was betted on the horse at this specific event (//at the example below the total bet stake for a horse was 5 Eur//).
  - **Potential win** of a horse is calculated by adding up all of the possible winnings of each bet that was made for it (//at the example it is 59.4 Eur//).
  - **Liability** = Win Stake - Potential Win. (//e.g. 5 - 59.4 = -54.4//. This means that if the concrete horse would win, the bettor would lose 54.4 Eur.)

**Important:** For a fixed place market, the total sum of liability is divided by the number of Each Way (EW) Places for more accurate data.
{{ :cashier:games:fieldsheetsmulti1.png?800 |}}

Liability is calculated and displayed only on the bet leg of the event that currently holds liability, typically the first upcoming event in the multileg bet. Once the first upcoming event from the multileg bet finishes, the liability calculation will shift to another event in the multibet sequence.

In the example below, the second event of the bet slip, while the first event is still active, has a liability equal to zero. When the first event from the slip finishes, the second event's liability value will be updated as follows:

  * If none of the horses that had bets won, the second event’s liability will be equal to 0, as none of the multibet tickets will be finalized as winners.

  * If any of the horses from the multibet will win, the second event’s liability will be calculated by formula: //Liability = Win Stake - Potential Win.//

**Important:** the same liability calculation logic is used for system bets as well.
{{ :cashier:games:fieldmultisecond.png?800 |}}
{{ :cashier:games:image10.gif?800 |}}

===== Field sheets for finished events =====
The data in the field sheets report for an event freezes when the event becomes inactive and betting is turned off. The liability calculation for the finished event includes all bets made until the event became inactive.

**To access the past events report:**
  - At the **Date** filter section choose the required date (events can be filtered out by choosing one of default date filters or entering a custom date range).
  - At the **Event State** section, add a checkmark on Finished status.
  - Click the **Load Events** button.
  - Once the events are loaded, navigate to the **Horse Racing** section.
  - Click on the preferred country to open a dropdown list of all filtered stadiums.
  - Select the preferred stadium from the dropdown list.
  - Click on the preferred event from the dropdown list of all filtered events.

{{ :cashier:games:fieldsheets_finished_event.gif?800 |}}

**Components of Finished event field sheet:**
  * Race status is displayed as **Inactive**;
  * Betting status is **Closed**;
  * **Winners of the race** are highlighted in green (for example, there is one Winner for the Win Market, and four winners for the Place Market);
  * Horse liability is indicated (as in the example, total horse liability is equal to -25, signifying that if the horse had won, the bettor would have lost 25 EUR);
  * Total event liability (in the example below it is equal to 0, as the winning horse did not have any bets, resulting in no loss for the bettor).
{{ :cashier:games:fieldsheetsfinished.png?800 |}}