Home Trading Cards & Memorabilia Forum

Using Ebay Marketplace Research

I must have been an accountant in a previous life.

I bought a fast-pass for Ebay marketplace research - two days for $3.
I am trying to determine the prices 1972 Topps BB cards, lots and sets were sold for over the past 2 months.

The fast pass allows access, but it displays the data in an HTML formatted table, 50 results at a time. Out of the 15,000 results, I've loaded 1700 so far.

I want to load this data into Excel in order to make sense of it: average sale prices for singles, lots, sets etc. So far I've had to paste-special - text into Word, clean it up, then dump it into Excel and clean it up even more over there.

Is there an easier way to do this?

Comments

  • Thats kinda like what I've been doing for a while. Once its in excel you can sort it and display it however you want (high to low price, alphabetized, number sold etc). Ive been copying and pasting auction results ever since I learned how.........
  • jskirwinjskirwin Posts: 700 ✭✭✭
    It would be nice if you could select the number of records at least.
    Doing it in 50 at a pop is reaally slllllllooooooooooowwww......
  • jskirwinjskirwin Posts: 700 ✭✭✭
    Just foundHammertap. It looks better, so I'll give it a whirl tonight.
Sign In or Register to comment.