Sitting here geeking around with keeping track of my FUT trading in Excel.
Got me wondering, if anyone knows a way to extract the current lowest BIN price from FUTBIN, so it would be auto updated in Excel, instead of manually doing it?
Looked at the code in Developer mode, and can only see the data hardcoded in.
Any fellow geeks that can help me out?
0
Comments
You could potentially write a Macro that does this:
1. You type the player name in a certain cell
2. Run the Macro
3. The Macro copies the player's name
4. The Macro opens up FUTBIN and pastes the player's name (or places it in the URL or something)
5. The Macro copies his price from FUTBIN
6. The Macro pastes it back in Excel
Do you start working on it ASAP?
Well, I do need to do some Excel stuff...
Nah you do it actually
My eyes are already squared from looking at Excel all day
Building some-kind of template for people to use, could be kinda fun, but not sure I have the time with this new IB-job.
Only limitation is that it will only run on windows.
You need to create some VBA code.
Using that VBA code you need to create an Internet Explorer object, which is not possible on OSX, due to not having IE.
And I'm primarily running OSX, so I won't take this project any further.
Edit:
I wonder if it's possible in Google Docs instead...
And you're idea would involve writing a program to check FUTBIN.
Why not cut out the middle man and write the program to check the Web App yourself.
You could set it to search for specific players every hour for example and update the price in your spreadsheet.
Actually just solved the problem by switching from Excel to Google Docs.
This formula will return the price table for Xbox IF N'Zonzi in Google Docs.
=IMPORTHTML("http://www.futbin.com/17/player/15235/N'Zonzi";"table";2)
Application.YourBrowser might work?
I looked into it earlier, it actually does look fairly easy. Hardest part will be pasting the data from FUTBIN, but that shouldn't be too big a problem.
It's actually kinda fun to play around with.
@Barslund I'm applying for jobs as a Financial Analyst right now, it wouldn't hurt to start writing some VBA programmes as practice tbh
Oh yeah? Nice one. Yeah stuff like this usually is fun to do tbh, I'll try the VBA tomorrow if I get time.
I officially started as an Private Equity associate today. No, it wouldn't hurt.
Nice one! Yeah Excel is so amazing sometimes, my entire Uni dissertation was done on it
Here's a link from Google Docs pulling data from FUTBIN
https://docs.google.com/spreadsheets/d/1nS6aWQhT-pDNf4n1UPRQiWKBT55W1GfHZ2Wq2P-nmqY/edit?usp=sharing
Only input cells are the URL
I don't think It's updating as it should, but there is a work-around for it.
Price only works between 1,000 and 999,000 due to the formating, but I'm sure that can be fixed if you change the formula - but who cares... there are only 10 cards in the game priced above 1 mill. coins.
I'm not to happy about how Google Docs handles autofilling of tables, so ideally this should be done in Excel.
Quality work mate! I'm sure the formula must be able to somehow take it over 1 million, but yeah it's pretty pointless atm. It's a start more than anything, and it works. I just opened it on my phone, will have a proper look when I have access to my laptop tomorrow. Otherwise nice one.
It is possible to make it work for whatever value.
It's just that the output from the "importhtml" function is a table, where i pick 1 cell from that table, which is the price.
Unfortunately on futbin it's not only the price but written like "1st X,XXX"
I removed the "1st" through a 'split' function, and google recognises "," as comma, so as soon you start going above 999.000 it reads it as 1 comma 000 comma 000, and can't read it as a number.
Just need to figure out a way to remove the comma's, so only the numerical values are returned.
But again...
For more extensive use, I would much rather have all of this in Excel, as is lacking in functionality when it comes to tables, and I'm not sure if HTML pulls is limited somehow?
Put a little bit more work into this, and people would definitely be able to use it as a tool for keeping track of their investments.
You can create your own list, that how I am following my players price.
Because it's very limited, if you want to keep track of your historial trading activities.
The Google Docs I linked is just the initial work, but adding on to it, you can builld a table that includes all your trading activities.
From that, you will be able to analyse your profit from each TOTW, player type, name, period, etc... depending on how much information you put down.
You can further extend that into Pivot tables / Figures if you like.
All of which is fairly easy, the hard part is getting updating data from FUTBIN.
I wouldn't go with Pivot tables myself, there are better options. I'll give this a good today at some point.
@benjisince93 haven't had time mate, need to properly put effort into it. Will be a weekend job now tbh
Lol quality.