The Average Price of a LEGO piece on Bricklink

[tchuk-norst]

Does anyone know if there is a way to find the mean price of all pieces on Bricklink short of actually calculating it by hand?

[Kristel]

I don't know the answer to your specific question, but my own purchases often end up around 10 cents US per part.

[Henchmen4Hire]

You might want to look at the "Price Guide Info" column when viewing a part in the Catalog.

[Grimmbeard]

Well, you could find the largest price, and the smallest price, and maybe do a factorial to find all the prices, and then do the average?

(Just an idea, not sure if the math'll work out.)

Edited May 9, 2013 by Grimmbeard

[Smartiepants]

on the various projects I have done & purchased the parts off both Bricklink & direct from the Lego store to complete the project the cost has always averaged out at 10p per part regardless of cost of individual bricks, this obviously includes postage costs, its strange the way it works out but I hope to cut costs now as I won approx 4kg of bits on eBay that will eventually save me money on future projects

saying that i am new to creating MOC projects so not that "street wise" to buying parts

[Sid Sidious]

I'm pretty sure there is a way to export prices from Bricklink to Excel using a third party program. If you can do this, type AVERAGE(Xn:Xm) Where Xn is the first cell of information and Xm is the last (make sure everything is in the same row or same column). I think this will only work for a specific part though. Bricklink is updated too often for the data to stay the same for every piece for longer than a few minutes, so the best way would most likely be using a script to simultaneously do what I mentioned above for every piece, and then taking a weighted average.