| Discussion Forum: Thread 258078 |
|
 |
| | | Author: | MI_Bricks  | | Posted: | Oct 1, 2019 12:25 | | Subject: | Pulling Data For Reference | | Viewed: | 96 times | | Topic: | Catalog | | Status: | Open | |
|
| 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 | | Posted: | Oct 1, 2019 12:47 | | Subject: | Re: Pulling Data For Reference | | Viewed: | 45 times | | Topic: | Catalog | |
|
| 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 | | Posted: | Oct 1, 2019 12:56 | | Subject: | Re: Pulling Data For Reference | | Viewed: | 26 times | | Topic: | Catalog | |
|
| 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 | | Posted: | Oct 1, 2019 13:56 | | Subject: | Re: Pulling Data For Reference | | Viewed: | 41 times | | Topic: | Catalog | |
|
| 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 | | Posted: | Oct 2, 2019 08:40 | | Subject: | Re: Pulling Data For Reference | | Viewed: | 72 times | | Topic: | Catalog | |
|
| 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!
|
|
|
|
|
|
|
USA, Michigan
)
)
)
)
