Discussion Forum: Price Guide(Post New Message)
Redisplay Messages: Compact | Brief | All | Full      Show Messages: All | Without Replies

 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Apr 27, 2022 07:11
 Subject: Re: Adjusting prices in bulk with Brcistore UK
 Viewed: 35 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52383)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 1001bricks
In Price Guide, Pippysblocks writes:
  Do any UK sellers know if you can bulk adjust stock in Brickstore to reflect
the UK 6th month ave. I've got it close but think it is still pulling in
the global 6th month average.
Thanks

You can't have a Country, Region or even with/without VAT price guide; as
BrickLink doesn't provide this information as is.
 Author: Turez View Messages Posted By Turez
 Posted: Apr 27, 2022 06:59
 Subject: Re: Price guide change USD to GBP
 Viewed: 37 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Turez (43)

Location:  Germany, Niedersachsen
Member Since Contact Type Status
Sep 18, 2012 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Zerut
BrickLink Catalog Administrator (?)
In Price Guide, Nordbart writes:
  In Price Guide, Turez writes:
  In Price Guide, LEGOLEGOUK writes:
  In Price Guide, Pippysblocks writes:
  Are you still logged in as if you log out it'll go to USD.

In Price Guide, LEGOLEGOUK writes:
  In Price Guide, LEGOLEGOUK writes:
  Hello, anyone know how to change USD to GBP in price guide?


Its still this same


I trye to log out and stay log on, its all time same (USD price)

The price guide currency is the same as your store currency, and for buyer accounts
it is always USD. So you have to upgrade your account to be able to change it.

My Price guide is in EURO and I'm no seller.

nordbart

Sorry I should have been more clear about this.

Yes, as a buyer you can change the currency for the normal price guide, but not
for the part out feature (and I think the question here was about that option
- see attached images).
 Author: Yogi_007 View Messages Posted By Yogi_007
 Posted: Apr 27, 2022 06:44
 Subject: Re: Price guide change USD to GBP
 Viewed: 28 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Yogi_007 (2876)

Location:  Australia, South Australia
Member Since Contact Type Status
Oct 19, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Yogi's Brick Den
  
  
  
  
  In Price Guide, LEGOLEGOUK writes:
  Hello, anyone know how to change USD to GBP in price guide?


Click on 'My BL'

Then click on 'settings'

Then select your preferred currency.

Save and your done

HTH

Yogi
 Author: hpoort View Messages Posted By hpoort
 Posted: Apr 27, 2022 06:42
 Subject: Re: Price guide change USD to GBP
 Viewed: 33 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

hpoort (412)

Location:  Netherlands, Groningen
Member Since Contact Type Status
Oct 11, 2014 Contact Member Buyer
Buying Privileges - OK
In Price Guide, Turez writes:
  In Price Guide, LEGOLEGOUK writes:
  In Price Guide, Pippysblocks writes:
  Are you still logged in as if you log out it'll go to USD.

In Price Guide, LEGOLEGOUK writes:
  In Price Guide, LEGOLEGOUK writes:
  Hello, anyone know how to change USD to GBP in price guide?


Its still this same


I trye to log out and stay log on, its all time same (USD price)

The price guide currency is the same as your store currency, and for buyer accounts
it is always USD. So you have to upgrade your account to be able to change it.

No, I - as a buyer only - see prices in EUR.
Both being logged in and not being logged in.

I believe you are right in that when you do have a shop, you can only see the
currency configured for your shop.
 Author: Nordbart View Messages Posted By Nordbart
 Posted: Apr 27, 2022 06:42
 Subject: Re: Price guide change USD to GBP
 Viewed: 28 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Nordbart (20)

Location:  Germany, Schleswig-Holstein
Member Since Contact Type Status
Apr 19, 2013 Contact Member Buyer
Buying Privileges - OK
In Price Guide, Turez writes:
  In Price Guide, LEGOLEGOUK writes:
  In Price Guide, Pippysblocks writes:
  Are you still logged in as if you log out it'll go to USD.

In Price Guide, LEGOLEGOUK writes:
  In Price Guide, LEGOLEGOUK writes:
  Hello, anyone know how to change USD to GBP in price guide?


Its still this same


I trye to log out and stay log on, its all time same (USD price)

The price guide currency is the same as your store currency, and for buyer accounts
it is always USD. So you have to upgrade your account to be able to change it.

My Price guide is in EURO and I'm no seller.

nordbart
 Author: Turez View Messages Posted By Turez
 Posted: Apr 27, 2022 06:36
 Subject: Re: Price guide change USD to GBP
 Viewed: 31 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Turez (43)

Location:  Germany, Niedersachsen
Member Since Contact Type Status
Sep 18, 2012 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Zerut
BrickLink Catalog Administrator (?)
In Price Guide, LEGOLEGOUK writes:
  In Price Guide, Pippysblocks writes:
  Are you still logged in as if you log out it'll go to USD.

In Price Guide, LEGOLEGOUK writes:
  In Price Guide, LEGOLEGOUK writes:
  Hello, anyone know how to change USD to GBP in price guide?


Its still this same


I trye to log out and stay log on, its all time same (USD price)

The price guide currency is the same as your store currency, and for buyer accounts
it is always USD. So you have to upgrade your account to be able to change it.
 Author: LEGOLEGOUK View Messages Posted By LEGOLEGOUK
 Posted: Apr 27, 2022 06:26
 Subject: Re: Price guide change USD to GBP
 Viewed: 36 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

LEGOLEGOUK (30)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 21, 2022 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: AaA+++
In Price Guide, Pippysblocks writes:
  Are you still logged in as if you log out it'll go to USD.

In Price Guide, LEGOLEGOUK writes:
  In Price Guide, LEGOLEGOUK writes:
  Hello, anyone know how to change USD to GBP in price guide?


Its still this same


I trye to log out and stay log on, its all time same (USD price)
 Author: Pippysblocks View Messages Posted By Pippysblocks
 Posted: Apr 27, 2022 06:03
 Subject: Re: Price guide change USD to GBP
 Viewed: 37 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Pippysblocks (4781)

Location:  United Kingdom, England
Member Since Contact Type Status
May 20, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Pippys Blocks
Are you still logged in as if you log out it'll go to USD.

In Price Guide, LEGOLEGOUK writes:
  In Price Guide, LEGOLEGOUK writes:
  Hello, anyone know how to change USD to GBP in price guide?


Its still this same
 Author: LEGOLEGOUK View Messages Posted By LEGOLEGOUK
 Posted: Apr 27, 2022 05:57
 Subject: Re: Price guide change USD to GBP
 Viewed: 30 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

LEGOLEGOUK (30)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 21, 2022 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: AaA+++
In Price Guide, LEGOLEGOUK writes:
  Hello, anyone know how to change USD to GBP in price guide?


Its still this same
 


 Author: Pippysblocks View Messages Posted By Pippysblocks
 Posted: Apr 27, 2022 05:52
 Subject: Adjusting prices in bulk with Brcistore UK
 Viewed: 46 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Pippysblocks (4781)

Location:  United Kingdom, England
Member Since Contact Type Status
May 20, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Pippys Blocks
Do any UK sellers know if you can bulk adjust stock in Brickstore to reflect
the UK 6th month ave. I've got it close but think it is still pulling in
the global 6th month average.
Thanks
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Apr 27, 2022 05:50
 Subject: Re: Price guide change USD to GBP
 Viewed: 30 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1185)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Yorbricks
In Price Guide, novabrick writes:
  In Price Guide, LEGOLEGOUK writes:
  Hello, anyone know how to change USD to GBP in price guide?

https://www.bricklink.com/v2/settings/pref_settings.page

Top Left corner "Viewing Currency"

You can change to your prefered currency

Christian

novabrick-team

The other useful thing after doing that is to use the "group by currency" on
the price guide page. That allows you to split GBP transactions from USD, EUR,
and all other currencies. This gives you a good idea of what items sold for in
the UK, as most GBP transactions will be from UK sellers. It's not perfect,
but at least gives some idea about regional prices.
 Author: novabrick View Messages Posted By novabrick
 Posted: Apr 27, 2022 05:44
 Subject: Re: Price guide change USD to GBP
 Viewed: 33 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

novabrick (14556)

Location:  Germany, Schleswig-Holstein
Member Since Contact Type Status
Mar 12, 2007 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: bunte-steine-aus-daenemark
In Price Guide, LEGOLEGOUK writes:
  Hello, anyone know how to change USD to GBP in price guide?

https://www.bricklink.com/v2/settings/pref_settings.page

Top Left corner "Viewing Currency"

You can change to your prefered currency

Christian

novabrick-team
 Author: LEGOLEGOUK View Messages Posted By LEGOLEGOUK
 Posted: Apr 27, 2022 05:39
 Subject: Price guide change USD to GBP
 Viewed: 101 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

LEGOLEGOUK (30)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 21, 2022 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: AaA+++
Hello, anyone know how to change USD to GBP in price guide?
 Author: retrogirl83 View Messages Posted By retrogirl83
 Posted: Apr 22, 2022 09:43
 Subject: Re: Vintage Lego 1589 pricing help
 Viewed: 70 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

retrogirl83 (0)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 22, 2022 Contact Member Buyer
Buying Privileges - OK
Thanks for the info. Do you have any idea where would be a good place to try
and sell it? I’m not in a massive rush so happy to wait for the right buyer to
come along.
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Apr 22, 2022 05:37
 Subject: Re: Vintage Lego 1589 pricing help
 Viewed: 67 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1185)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Yorbricks
In Price Guide, retrogirl83 writes:
  Hi all, I recently discovered a vintage Lego 1589 set in my loft. It seems to
be brand new but the box has been opened. The contents is pristine and includes
all the appropriate pieces and stickers. It was also packaged with the original
box it came in from Lego. I’m not sure how to price this item as I can’t seem
to find one in this kind of condition online. I live in the UK. Would be really
great full of some expert help with this one please.

Many thanks

J

I think you'd have to sell it as used, as there is not really proof that
it is new if it has been opened, even though the stickers have not been applied.
There is another one in the UK for sale here at £270 with stickers applied. I
reckon you could stick it on ebay as an auction starting at probably £350 and
see where it goes from there, mentioning it is opened but parts look immaculate
and the sticker sheet is unused. I'd list it as used but say it looks like
new in the description. You'll have an issue that if you list as new as the
condition and someone gets it and complains that it has been opened. You might
get away with starting at £500 but a lower start price is likely to get people
interested.

Alternatively you could put a higher price as a buy it now and allow offers and
see if you get any.

But demand might not be there at a high price, given the part out value is quite
low (someone wanting the parts (without stickers) to build the set could buy
them for about £50). The only one that has sold here in six months was (likely)
from a Hungarian seller. You need to find a collector that will appreciate and
more importantly pay for the unused sticker sheet, box and instructions. There
are people that will, if you can find them!
 Author: retrogirl83 View Messages Posted By retrogirl83
 Posted: Apr 22, 2022 05:14
 Subject: Vintage Lego 1589 pricing help
 Viewed: 99 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

retrogirl83 (0)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 22, 2022 Contact Member Buyer
Buying Privileges - OK
Hi all, I recently discovered a vintage Lego 1589 set in my loft. It seems to
be brand new but the box has been opened. The contents is pristine and includes
all the appropriate pieces and stickers. It was also packaged with the original
box it came in from Lego. I’m not sure how to price this item as I can’t seem
to find one in this kind of condition online. I live in the UK. Would be really
great full of some expert help with this one please.

Many thanks

J
 


 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Apr 14, 2022 13:52
 Subject: Re: Ridiculous prices \ AVG Price's broken
 Viewed: 67 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52383)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 1001bricks
  The price guide suck in my opinion. How do you use it to value a set with defects
or was the AVG price had all defected sets and yours was not? Look at the current
listings.


Price guide is like the Argus for automobile.

It doesn't mean ANYTHING but it's very helpful.

Hoping it helps - even if I doubt it does
 Author: legoman77 View Messages Posted By legoman77
 Posted: Apr 14, 2022 13:46
 Subject: Re: Ridiculous prices \ AVG Price's broken
 Viewed: 36 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

legoman77 (3628)

Location:  USA, Texas
Member Since Contact Type Status Collage
Jan 22, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store: 77's Bricks & Sets
In Price Guide, RuiBraga writes:
  Hello guys,

Can someone check this store 613 Bricks (https://www.bricklink.com/store.asp?p=613)
The prices are insanely high and it will break the purpose of the avg prices.
Example:
Queen Anne's Revenge
Lot ID: 288191095 Item No: 4195-1
Price:
US $64,990.00
(~EUR 59,700.8515)

Please investigate.

Thanks.

I never used the average price function. I pulled up what was listed and priced
accordingly. Price depended on whether I wanted to be the lowest price and sell
quickly or somewhere in the middle if I wanted to reply on my reputionation and
feedback and no rush to sell.
The price guide suck in my opinion. How do you use it to value a set with defects
or was the AVG price had all defected sets and yours was not? Look at the current
listings.
John P
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Apr 14, 2022 03:52
 Subject: Re: Ridiculous prices \ AVG Price's broken
 Viewed: 40 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1185)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Yorbricks
  
100 items are sold for $1.00
1 item is sold for $100.00
Mean or Average = $1.98, which is 200% of the expected and actual meaningful
average.
Let's say I use this for setting my selling price. I will be the most expensive
one on BrickLink (except for the $100.00 one of course), but I will believe I'm
offering at the average price, thinking I offer at a competitive price.

It is obviously fake data, such wide variations in sold data are highly unlikely.
Especially as these are sold prices, they are meaningful. That someone paid $100
presumably means it was a genuine sale. Of course we don't know what was
correct, was it a seller pricing high and getting a buyer willing to pay 100x
too much (unlikely), or was it a seller error, listing 100 at $1 instead of 1
at $100. The latter would likely be snapped up instantly.

This made up data shows one thing though - know what you sell. If you had a $100
item and someone else messed up and listed it as 100 at $1, would you blindly
follow their error price because that is what the biased average is, or would
you check sales data? Either way the $1 or $2 average should seem way off if
you understood the value of the item.

You won't be the only one selling at that price. Why would you be the only
person on bricklink that uses the average sold price? If you are, they should
remove the ability to populate with price guide data, as it is not being used
by any other seller. More likely, many other people will be listing at the same
average.
 Author: Gaston.La.Brick View Messages Posted By Gaston.La.Brick
 Posted: Apr 14, 2022 03:36
 Subject: Re: Ridiculous prices \ AVG Price's broken
 Viewed: 29 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Gaston.La.Brick (1841)

Location:  Belgium
Member Since Contact Type Status
Nov 12, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: The Rolling Bricks
In Price Guide, yorbrick writes:
  In Price Guide, Gaston.La.Brick writes:
  
  
  As I mentioned before, the correct way for it's intended purpose would
be to exclude the lowest and highest 10% of the prices. This would filter out
the extremes (both downwards and upwards). A new calculated variable "Avg. Price
Percentile (10th-90th)" could be introduced.

Why exclude the extreme 10%, what is correct about that? Why not 2%, 5%, 16.67%
or 49%?
The intended purpose is to report the mean, which is what it does.

I don't agree. The mathematical value is indeed the mean (I think, English
is not my native language). However, I do think the intended purpose was not
to give the mean, but to give an indication to both buyer and seller what a realistic,
average price is for which an item has been sold and is on sale now. I can't
be sure, I wasn't there when it was discussed. As long as extremes are in
that equation, the meaning behind that value has lost its purpose.

Do note I didn't say to change the value of the "Average" variable. It should
remain the mathematical correct one. But instead introduce a new one ("X Percentile
Average", or what you want to call) that actually has a better meaning to it's
value. When you ask what's correct about that: it is an statistically correct
and commonly used way to filter out extreme values polluting the meaning or trend
value. It's also referred to as "removing outliers".
https://www.statology.org/remove-outliers/
https://statisticsbyjim.com/basics/remove-outliers/

On the exact percentage: could be 1%, 2%, 10%. Or it could be filter out the
bottom 3 and top 3 values. Whatever would be decided (I'm not statisticus),
it would give me a better meaning to some of the values.

None of that is better, just different. There is usually a very important thing
if you remove data from any analysis because you believe it doesn't fit -
you report what you remove and why, and still report the true mean before you
bias it by removing data.
Filtering out things like the bottom and top three results is not a good idea.
For items where many sales are made, it makes little to no difference.

100 items are sold for $1.00
1 item is sold for $100.00
Mean or Average = $1.98, which is 200% of the expected and actual meaningful
average.
Let's say I use this for setting my selling price. I will be the most expensive
one on BrickLink (except for the $100.00 one of course), but I will believe I'm
offering at the average price, thinking I offer at a competitive price.

I understand you will never even consider this, but for me the average value
has no purpose this way, as I can't use it for deciding if an offered price
is actually competitive or not. Without of course checking item per item, by
manual effort.

Where
  only a few sales are made, it can have a huge effect. For example, if 10 sales
are made, you throw away 60% of your data. If just 7, you are taking the median.
For six or fewer sales, you throw away all the data.

Why 60% is thrown away? As I said, the exact formula should be well thought.
I could be top/bottom 10%, so for 10 sales only 20% is thrown away. And even
then, it shouldn't always be that case, but only for situation where there
is a very large deviation at the bottom and top prices.

Of course the algorithm needs to be a bit more intelligent/smart, as to decide
when to drop which outliers. Again, I'm not a statisticus, but I'm sure
there are intelligent formulas that cover these problems to deliver actual usable
data.
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Apr 14, 2022 03:35
 Subject: Re: Ridiculous prices \ AVG Price's broken
 Viewed: 30 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1185)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Yorbricks
  
Let's say an item is sold 10 times for 1.00 dollar but once for 10 dollars.
The current (mathematical correct) average would be 9.90$ (9x 1.00$ + 1x 10.00$
= 99.00$ / 10 items).

Better would be to exclude the extremes, which would result in an average of
1.00$ as the sale for 10.00$ is omitted.

Your calculation is wrong. 9x1 + 10 = 19, not 99. The average would be $1.90.

Yes you could exclude the high value, but why is that better? You have excluded
useful data. Those 9 $1 sales could all be from the same seller that undervalued
the item, or purposely manipulated the price with fake sales.
 Author: Yo_Yo_Flamingo View Messages Posted By Yo_Yo_Flamingo
 Posted: Apr 14, 2022 00:28
 Subject: Re: Ridiculous prices \ AVG Price's broken
 Viewed: 54 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Yo_Yo_Flamingo (4570)

Location:  USA, New York
Member Since Contact Type Status
Jan 9, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Set You Up
In Price Guide, Gaston.La.Brick writes:
  
  There's two lists on the price guide, "sold" items and "for sale" items.
So while these listing don't mess up the "sold" average, they greatly change
the "for sale" average (though I don't ever look at that anyways).

For items that aren't sold that much (and have a larger number of items in
the "for sale" as in the "sold" category), you often need to rely on the "for
sale" average price.
And even for the "sold" values, they sometimes include extremely low or high
values. That's of course fine, but it makes the mathematical average useless
when it's being used to base your own price upon.

Let's say an item is sold 10 times for 1.00 dollar but once for 10 dollars.
The current (mathematical correct) average would be 9.90$ (9x 1.00$ + 1x 10.00$
= 99.00$ / 10 items).

Better would be to exclude the extremes, which would result in an average of
1.00$ as the sale for 10.00$ is omitted.

I agree with your position of excluding outliers from the calculation, but the
engineer in my is going to drive me mad until I correct that math.

in that example, 10$ for one item + $10 for another ten at a buck a piece = $20/11,
for an average of $1.81.
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Apr 13, 2022 16:28
 Subject: Re: Ridiculous prices \ AVG Price's broken
 Viewed: 51 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1185)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Yorbricks
In Price Guide, Gaston.La.Brick writes:
  
  
  As I mentioned before, the correct way for it's intended purpose would
be to exclude the lowest and highest 10% of the prices. This would filter out
the extremes (both downwards and upwards). A new calculated variable "Avg. Price
Percentile (10th-90th)" could be introduced.

Why exclude the extreme 10%, what is correct about that? Why not 2%, 5%, 16.67%
or 49%?
The intended purpose is to report the mean, which is what it does.

I don't agree. The mathematical value is indeed the mean (I think, English
is not my native language). However, I do think the intended purpose was not
to give the mean, but to give an indication to both buyer and seller what a realistic,
average price is for which an item has been sold and is on sale now. I can't
be sure, I wasn't there when it was discussed. As long as extremes are in
that equation, the meaning behind that value has lost its purpose.

Do note I didn't say to change the value of the "Average" variable. It should
remain the mathematical correct one. But instead introduce a new one ("X Percentile
Average", or what you want to call) that actually has a better meaning to it's
value. When you ask what's correct about that: it is an statistically correct
and commonly used way to filter out extreme values polluting the meaning or trend
value. It's also referred to as "removing outliers".
https://www.statology.org/remove-outliers/
https://statisticsbyjim.com/basics/remove-outliers/

On the exact percentage: could be 1%, 2%, 10%. Or it could be filter out the
bottom 3 and top 3 values. Whatever would be decided (I'm not statisticus),
it would give me a better meaning to some of the values.

None of that is better, just different. There is usually a very important thing
if you remove data from any analysis because you believe it doesn't fit -
you report what you remove and why, and still report the true mean before you
bias it by removing data.

Filtering out things like the bottom and top three results is not a good idea.
For items where many sales are made, it makes little to no difference. Where
only a few sales are made, it can have a huge effect. For example, if 10 sales
are made, you throw away 60% of your data. If just 7, you are taking the median.
For six or fewer sales, you throw away all the data.
 Author: Gaston.La.Brick View Messages Posted By Gaston.La.Brick
 Posted: Apr 13, 2022 15:08
 Subject: Re: Ridiculous prices \ AVG Price's broken
 Viewed: 46 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Gaston.La.Brick (1841)

Location:  Belgium
Member Since Contact Type Status
Nov 12, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: The Rolling Bricks
  
  As I mentioned before, the correct way for it's intended purpose would
be to exclude the lowest and highest 10% of the prices. This would filter out
the extremes (both downwards and upwards). A new calculated variable "Avg. Price
Percentile (10th-90th)" could be introduced.

Why exclude the extreme 10%, what is correct about that? Why not 2%, 5%, 16.67%
or 49%?
The intended purpose is to report the mean, which is what it does.

I don't agree. The mathematical value is indeed the mean (I think, English
is not my native language). However, I do think the intended purpose was not
to give the mean, but to give an indication to both buyer and seller what a realistic,
average price is for which an item has been sold and is on sale now. I can't
be sure, I wasn't there when it was discussed. As long as extremes are in
that equation, the meaning behind that value has lost its purpose.

Do note I didn't say to change the value of the "Average" variable. It should
remain the mathematical correct one. But instead introduce a new one ("X Percentile
Average", or what you want to call) that actually has a better meaning to it's
value. When you ask what's correct about that: it is an statistically correct
and commonly used way to filter out extreme values polluting the meaning or trend
value. It's also referred to as "removing outliers".
https://www.statology.org/remove-outliers/
https://statisticsbyjim.com/basics/remove-outliers/

On the exact percentage: could be 1%, 2%, 10%. Or it could be filter out the
bottom 3 and top 3 values. Whatever would be decided (I'm not statisticus),
it would give me a better meaning to some of the values.
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Apr 13, 2022 14:39
 Subject: Re: Ridiculous prices \ AVG Price's broken
 Viewed: 47 times
 Topic: Price Guide
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1185)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Yorbricks
In Price Guide, Gaston.La.Brick writes:
  In Price Guide, Sadler_Bricks writes:
  Could be a mistake. But besides this i have seen other stores do this. The prices
have been broken for a good while in my opinion.

Sadler_bricks

Correct.
There have been (and will be) numerous discussions on how "Average Price" is
calculated. Currently, it's the mathematical correct way.

As I mentioned before, the correct way for it's intended purpose would
be to exclude the lowest and highest 10% of the prices. This would filter out
the extremes (both downwards and upwards). A new calculated variable "Avg. Price
Percentile (10th-90th)" could be introduced.

Why exclude the extreme 10%, what is correct about that? Why not 2%, 5%, 16.67%
or 49%?
The intended purpose is to report the mean, which is what it does.

Next Page: 5 More | 10 More | 25 More | 50 More | 100 More