nursejason
New Member
- Joined
- Jul 12, 2011
- Messages
- 1
Well I have a few different things I needed some assistance with. I tried my hand at searching, and either came up with inconclusive results or didn't know how to type my question in to google to get an ideal response. I am however selling trading cards, and was looking to set up an excel spreadsheet with my current inventory, trading cost, and ebay costs. Currently my main spreadsheet is something like this
Card Name - Set it's from - rarity - quantity on hand - trading cost - eBay cost - listed - sold - quantity sold - price received - +shipping - Fees - -Shipping - subtotal.
Probably a bit overboard on the fields but I had a few different things I was looking to do. Firstly, I want there to be some sort of conditional formatting done (which I couldn't find within excel) to say, "Okay, if you don't have any cards on hand of a quantity, or if you sold a quantity of x card equal to the quantity you originally had, then the name of the card gets a strikethrough."
Another one of the big things I wanted to do was to write a program in java to take a .csv of my spreadsheet, and use the eBay API to automatically input what the cards were going for on eBay. However I've found a website or two that does that itself. For one of the card brands I started doing this with (Magic The Gathering) there is a list that checks ebay prices daily and updates them, tracking over the last 7 days. The website is : http://magictraders.com/pricelists/current-magic-weekly
I noticed that I can have Excel import that list (I was going to put it on sheet 3) every time I open my spreadsheet, and I would have really liked a formula that said "If card name from main sheet = card name from sheet 3, price of card name on sheet 3 = eBay cost on sheet 1." I ran into two problems here, firstly, that website has no special pasting. It's just text that isn't seperated whatsoever. I noticed I could separate everything by the commas that are listed, but every time it pulls the data back in, it would overwrite the formatting change.
Furthermore I have no idea where or how I would implement the formula that would do that. I think those are all the questions I have for now, so please help!
Card Name - Set it's from - rarity - quantity on hand - trading cost - eBay cost - listed - sold - quantity sold - price received - +shipping - Fees - -Shipping - subtotal.
Probably a bit overboard on the fields but I had a few different things I was looking to do. Firstly, I want there to be some sort of conditional formatting done (which I couldn't find within excel) to say, "Okay, if you don't have any cards on hand of a quantity, or if you sold a quantity of x card equal to the quantity you originally had, then the name of the card gets a strikethrough."
Another one of the big things I wanted to do was to write a program in java to take a .csv of my spreadsheet, and use the eBay API to automatically input what the cards were going for on eBay. However I've found a website or two that does that itself. For one of the card brands I started doing this with (Magic The Gathering) there is a list that checks ebay prices daily and updates them, tracking over the last 7 days. The website is : http://magictraders.com/pricelists/current-magic-weekly
I noticed that I can have Excel import that list (I was going to put it on sheet 3) every time I open my spreadsheet, and I would have really liked a formula that said "If card name from main sheet = card name from sheet 3, price of card name on sheet 3 = eBay cost on sheet 1." I ran into two problems here, firstly, that website has no special pasting. It's just text that isn't seperated whatsoever. I noticed I could separate everything by the commas that are listed, but every time it pulls the data back in, it would overwrite the formatting change.
Furthermore I have no idea where or how I would implement the formula that would do that. I think those are all the questions I have for now, so please help!
