Since it appears a few people are using this I figured I'd make a thread and use it to update everyone interested on things I've added. Feel free to ask questions or suggest things I could add. Public Version - FIFA 2020 Trade Tracker
Massive Updates - Guide now included within the spreadsheet and the forum post.
I hate the effort of trading. Got annoyed a few years ago trading IF’s. Literally seeing my cards go 10-20 cycles without selling yet seeing other cards go for 30-40k more. After investing about 500k I think I made about 100k profit
@Absting159 if you copy the formula below to the L column, it will update the column soon as you enter a sale price
=IF(J6<>"","Y","")
=IF(J6<>"","Y","N") includes an N for unsold players also which helps with the figure in A2
The only issue I have is for players which I have bought, but not yet listed, (value in G, no value in F) it shows up as an N in column L, which then counts it as being in the transfer list in A2, which is not true.
@rickir1
That’s easy I think. You have nested IF statements. Haha. I’ll look tonight, unfortunately I have worn and am US time so won’t be till tomorrow for you guys.
I’ll add it and play on my version. That is a great idea.
yeah that works but it impacts the other count formulas, but a re-gig of other formula should get it to a point where it is all fairly automated, i'll have a proper look and see what can be changed around
This thread makes me feel stupid. Delete it please
LOL - excel is like learning code; its the same way of thinking. Some people are good at it, some will just use what we create. Like learning a language. . I was forced to learn this during my Bachelors as my major was finance.
This thread makes me feel stupid. Delete it please
LOL - excel is like learning code; its the same way of thinking. Some people are good at it, some will just use what we create. Like learning a language. . I was forced to learn this during my Bachelors as my major was finance.
I actually spent a semester studying it when I was in college in the states. Only really covered the basics tho
@Absting159 if you copy the formula below to the L column, it will update the column soon as you enter a sale price
=IF(J6<>"","Y","")
=IF(J6<>"","Y","N") includes an N for unsold players also which helps with the figure in A2
The only issue I have is for players which I have bought, but not yet listed, (value in G, no value in F) it shows up as an N in column L, which then counts it as being in the transfer list in A2, which is not true.
Perhaps someone can figure out that formula?
@rickir1 whats the difference between G & F (coulmn F (BIN) whats the point of it?)
@UM4R@rickir1 - Rick's formula works fine; I added it to mine. Will update the pub one soon.
Rick - when I buy and don't list, I just enter the name on the left, don't put anything else and nothing else will get counted. Because you shouldn't have the formula in M dragged down infinitely as it'll count EVERY 'N' as a player in your TP. You grade that along with L and N when you add a new player .
The count, average, and if statements rely on the Y or N to tell me sold or not.
So Rick - look at the pic. . if you just enter player's names - and DON'T drag the formula you'll be fine, then you can update later. Notice, no N in Row 136.
Umar - G is what you paid; F is what the current BIN is.
This is specific for when you've had people in your pile for a long period and want to see your liquidity if you sold everything at its current BIN; because that can help you see if you can afford someone you're looking to get.
Players drop hard sometimes, i wanted to be able to see my total club value
it should fix all the counts at the top and should be able to copy the formula all the way down for L, and be able to enter all the purchase info at the same time
it should fix all the counts at the top and should be able to copy the formula all the way down for L, and be able to enter all the purchase info at the same time
i think everything else should be good to go
That one didn't work for me, but it may be down to the way I'm using the sheet.
For column G, I put in the cost as soon as I buy the player. I leave column H blank until I list the player, at which time I put in the BIN price I list it for (not the market price as the OP suggests).
Comments
Thanks guys! Suggestions welcome. I love a challenge. Haha.
Looks great, if I find any improvement, i’ll Be sure to let you know! Thanks
It's a google document.
=IF(J6<>"","Y","")
I hate the effort of trading. Got annoyed a few years ago trading IF’s. Literally seeing my cards go 10-20 cycles without selling yet seeing other cards go for 30-40k more. After investing about 500k I think I made about 100k profit
=IF(J6<>"","Y","N") includes an N for unsold players also which helps with the figure in A2
The only issue I have is for players which I have bought, but not yet listed, (value in G, no value in F) it shows up as an N in column L, which then counts it as being in the transfer list in A2, which is not true.
Perhaps someone can figure out that formula?
I’ll add it and play on my version. That is a great idea.
That’s easy I think. You have nested IF statements. Haha. I’ll look tonight, unfortunately I have worn and am US time so won’t be till tomorrow for you guys.
yeah that works but it impacts the other count formulas, but a re-gig of other formula should get it to a point where it is all fairly automated, i'll have a proper look and see what can be changed around
LOL - excel is like learning code; its the same way of thinking. Some people are good at it, some will just use what we create. Like learning a language. . I was forced to learn this during my Bachelors as my major was finance.
I actually spent a semester studying it when I was in college in the states. Only really covered the basics tho
@rickir1 whats the difference between G & F (coulmn F (BIN) whats the point of it?)
Rick - when I buy and don't list, I just enter the name on the left, don't put anything else and nothing else will get counted. Because you shouldn't have the formula in M dragged down infinitely as it'll count EVERY 'N' as a player in your TP. You grade that along with L and N when you add a new player
The count, average, and if statements rely on the Y or N to tell me sold or not.
So Rick - look at the pic. . if you just enter player's names - and DON'T drag the formula you'll be fine, then you can update later. Notice, no N in Row 136.
Umar - G is what you paid; F is what the current BIN is.
This is specific for when you've had people in your pile for a long period and want to see your liquidity if you sold everything at its current BIN; because that can help you see if you can afford someone you're looking to get.
Players drop hard sometimes, i wanted to be able to see my total club value
Yes it is
if you change the formula in a2 to:
=COUNTIFS(I:I,"", G:G,">0")
it should fix all the counts at the top and should be able to copy the formula all the way down for L, and be able to enter all the purchase info at the same time
i think everything else should be good to go
I just need to update a few others. There are about 10 other places; I'll look at that later but you're right haha.
That one didn't work for me, but it may be down to the way I'm using the sheet.
For column G, I put in the cost as soon as I buy the player. I leave column H blank until I list the player, at which time I put in the BIN price I list it for (not the market price as the OP suggests).