example spreadbet spreadsheet

	A	B	C	D	E	F	H	I	J	K	L
1	Example Spread Bet account				Cash	£25,000
2					Running P&L	#N/A	Auto warning:	#N/A
3					Account equity	#N/A	Gearing	#N/A	(where 100% = no gearing, 150% warning, 200% dire warning!)
4
5	Totals					£52,950		#N/A	#N/A	#N/A
6	Ticker	Company name	Bet size (£/pt)	Equivalent no. shares	Opening price (pence per share)	Opening exposure	Share price now	Current exposure	Profit/(loss) £	Profit/ (loss) %	Diversification
7	LON:TSCO	Tesco PLC	100	10,000	216	£21,600	457.6	£45,760	£24,160	111.9%	#N/A
8	LON:SOM	Somero Enterprises Inc	50	5,000	122	£6,100	235	£11,750	£5,650	92.6%	#N/A
9	LON:AXS	Accsys Technologies Plc	50	5,000	65	£3,250	60.94	£3,047	-£203	-6.2%	#N/A
10	LON:BOO	#N/A	500	50,000	25	£12,500	#N/A	#N/A	#N/A	#N/A	#N/A
11	LON:CALL	#N/A	50	5,000	190	£9,500	#N/A	#N/A	#N/A	#N/A	#N/A
12											#N/A
13											#N/A
14											#N/A
15											#N/A
16
17
18		Colour coding - user input fields are this colour. Everything else should be automatic.
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100