Discussion Forum: Thread 258078

 Author: MI_Bricks View Messages Posted By MI_Bricks
 Posted: Oct 1, 2019 12:25
 Subject: Pulling Data For Reference
 Viewed: 86 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

MI_Bricks (119)

Location:  USA, Michigan
Member Since Contact Type Status
Jan 7, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: MI Bricks
I bought a huge bin (approx. 40 lbs. for $40!) of LEGO and am in the process
of sorting the minfigs. So far I am at about 125 that I have positively identified
here in the catalog. I have about 75 more heads and a similar number of bodies
and legs.

Is there a way to say make an Excel spreadsheet that will automatically pull
data from the catalog so I can sort which ones are of value and which ones are
relatively common.

I started a spreadsheet and added a link to each figures page in the database,
but that doesn't help me sort them by value.

Thanks for any help!
 Author: runner.caller View Messages Posted By runner.caller
 Posted: Oct 1, 2019 12:47
 Subject: Re: Pulling Data For Reference
 Viewed: 39 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

runner.caller (932)

Location:  USA, South Dakota
Member Since Contact Type Status
Jan 18, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: A Minifig Galore Store
In Catalog, MI_Bricks writes:
  I bought a huge bin (approx. 40 lbs. for $40!) of LEGO and am in the process
of sorting the minfigs. So far I am at about 125 that I have positively identified
here in the catalog. I have about 75 more heads and a similar number of bodies
and legs.

Is there a way to say make an Excel spreadsheet that will automatically pull
data from the catalog so I can sort which ones are of value and which ones are
relatively common.

I started a spreadsheet and added a link to each figures page in the database,
but that doesn't help me sort them by value.

Thanks for any help!

I once made something similar to what you're asking at my old job using macros
and web queries in excel. The macro would loop through each line on excel and
use the itemID to spit out the pricelist sales history on New and Used.

I would use it to find the most valuable versions of figures (example, most valuable
battle droids in picture.

Sadly, I lost this spreadsheet when I left that job.
 
 Author: runner.caller View Messages Posted By runner.caller
 Posted: Oct 1, 2019 12:56
 Subject: Re: Pulling Data For Reference
 Viewed: 23 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

runner.caller (932)

Location:  USA, South Dakota
Member Since Contact Type Status
Jan 18, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: A Minifig Galore Store
Just scanning my insta for some of the legacy ones I ran. Looks like I did an
astromech one, and a Yoda one too.
 






 Author: VOTB View Messages Posted By VOTB
 Posted: Oct 1, 2019 13:56
 Subject: Re: Pulling Data For Reference
 Viewed: 34 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

VOTB (52)

Location:  USA, Oregon
Member Since Contact Type Status
Mar 22, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Valley Of The Bricks
I have been working on a way to do this. There are a few ways to go, one with
macros, another with web scrapers, having an API with the data would be helpful.
The main issue I come against is the server draw. I am pretty convinced this
is one of the reasons we get so many 500 errors. There are those out there pulling
pricing for hundreds or thousands of parts every day. This draws the BL server
down. I read somewhere that bots and spiders are not permitted. Therefore if
found out you could be banned. Currently, I have only scrapers pulling pricing
from retail locations, then I manually go in and pull pricing from BL on items
I feel may be profitable.

It would be nice if BL would simply publish a daily csv file that included all
the pricing of each piece. Then we could just plug that into a spreadsheet or
google doc with vlookup and have a really good simple pricing tool.

Not to get too many people riled up, but I am hopeful that XP will have some
updates that will help us in this regard.
 Author: starbeanie View Messages Posted By starbeanie
 Posted: Oct 2, 2019 08:40
 Subject: Re: Pulling Data For Reference
 Viewed: 65 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

starbeanie (6925)

Location:  USA, Virginia
Member Since Contact Type Status
Jan 23, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Starbeanie's Bricks
http://brickstock.patrickbrans.com/


In Catalog, MI_Bricks writes:
  I bought a huge bin (approx. 40 lbs. for $40!) of LEGO and am in the process
of sorting the minfigs. So far I am at about 125 that I have positively identified
here in the catalog. I have about 75 more heads and a similar number of bodies
and legs.

Is there a way to say make an Excel spreadsheet that will automatically pull
data from the catalog so I can sort which ones are of value and which ones are
relatively common.

I started a spreadsheet and added a link to each figures page in the database,
but that doesn't help me sort them by value.

Thanks for any help!