/R/FIFA Discord - Investment Tracker

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	R	S	T	V
1																			#REF!
2				Instructions							Overview					Quick Sales Tracker
3				Every row represents a single investment. Add the card info as well as pricing info (orange coloured cells under 'investment' and 'estimated income'). When you cash in on your investment, fill in the average sell price. All the other info is calculated automatically. Please note that editing any of the cells that are not orange coloured (besides the card info) will cause malfunctioning. Contact me through Discord with any questions and bug reports.							Investment		Total Players		156	To keep track of bulk sales, before summing them and updating the main sheet
4													Overall Invested		8515000
5													Currently Invested		3220000	Card	Avg. Sell Price	Amount
6											Estimated Income (not sold+sold)		Estimated Turnover		10300000	Dost	3800	7
7	created by buur.												Estimated Profit (after tax)		1270000	Dost	2300	13
8	/R/FIFA Discord												Estimated ROI		14.91%
9	https://discord.gg/JQqWVBt										Actual Income (based on everything sold)		Total Cost of Players Sold		5295000
10	#trading			THIS IS AN EXAMPLE SHEET, USE THE "CLEAN SHEET" TO START INVESTING. USE THE "BETA" SHEET IF YOU WANT LIVE PRICES FROM FUTWIZ (CURRENTLY TESTING).									Turnover		5932000
11	Last updated: 2018-09-16												Profit (After Tax)		340400
12	Version 1.1												ROI		6.43%
13
14
15	Card Info				Investment			Estimated Income				Actual Income
16	Name	Type	Rating	Futbin	# Bought	Avg Buy Price	Total Cost	Est. Sell	Total Est. Sell	Est. Profit (after tax)	Est. ROI %	Avg. Sell	Total Sell	Profit (after tax)	ROI %
17	Mkhitaryan	SIF	87		20	225000	4500000	150000	3000000	-1650000	-36.67%	160000	3200000	-1460000	-32.44%
18	Dembele	IF	81	https://www.futbin.com/18/player/15668/Moussa%20Demb%C3%A9l%C3%A9/	23	15000	345000	30000	690000	310500	90.00%	34000	782000	397900	115.33%
19	Alessandrini	IF	82	https://www.futbin.com/18/player/15601/Romain%20Alessandrini/	30	15000	450000	60000	1800000	1260000	280.00%	65000	1950000	1402500	311.67%
20	Kimmich	TOTGS	87		23	120000	2760000	170000	3910000	954500	34.58%
21	Gnabry	IF	83		10	40000	400000	70000	700000	265000	66.25%
22	Dost	NIF	83		50	1200	60000	4000	200000	130000	216.67%
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