This thread is very helpful thank you!
|
  
|
Items For Sale
Arrange the purchasing and selling of items.
TOPIC | [HUB] The Community Gem Exchange
Oh man, this sheet is so handy, why haven't I found this earlier??
@vihuff
Something I noticed: Currently the ratio seems to be calculated as the mean value of the entries of everyone.
Now when comparing it to the best offers, it does not match them.
Currently the ratio is supposed to be 842:1, but the highest buying and lowest selling offers are 900:1 and 860:1 respectively.
Maybe the ratio should not be calculated by ALL entries but e.g. by top three best buying and selling deals. Then it would be 878:1 which fits the currently best offers way better.
@vihuff
Something I noticed: Currently the ratio seems to be calculated as the mean value of the entries of everyone.
Now when comparing it to the best offers, it does not match them.
Currently the ratio is supposed to be 842:1, but the highest buying and lowest selling offers are 900:1 and 860:1 respectively.
Maybe the ratio should not be calculated by ALL entries but e.g. by top three best buying and selling deals. Then it would be 878:1 which fits the currently best offers way better.
Oh man, this sheet is so handy, why haven't I found this earlier??
@vihuff
Something I noticed: Currently the ratio seems to be calculated as the mean value of the entries of everyone.
Now when comparing it to the best offers, it does not match them.
Currently the ratio is supposed to be 842:1, but the highest buying and lowest selling offers are 900:1 and 860:1 respectively.
Maybe the ratio should not be calculated by ALL entries but e.g. by top three best buying and selling deals. Then it would be 878:1 which fits the currently best offers way better.
@vihuff
Something I noticed: Currently the ratio seems to be calculated as the mean value of the entries of everyone.
Now when comparing it to the best offers, it does not match them.
Currently the ratio is supposed to be 842:1, but the highest buying and lowest selling offers are 900:1 and 860:1 respectively.
Maybe the ratio should not be calculated by ALL entries but e.g. by top three best buying and selling deals. Then it would be 878:1 which fits the currently best offers way better.
|
    he/him FR+9
|
|
Used the sheet to make two transactions, I always dreaded buying gems because of making a thread and all that, so this came super handy, thank you so much!
Used the sheet to make two transactions, I always dreaded buying gems because of making a thread and all that, so this came super handy, thank you so much!
Check out my Art Shop!
CLOSED slots
CLOSED slots
replying to this for later reference for when i have a crap ton of treasure for some odd reason
replying to this for later reference for when i have a crap ton of treasure for some odd reason
@vihuff
You need an "online / offline" status column next to the user names on each of the buying & selling tabs. Users update this for themselves, but you can add a script to the spreadsheet that will insert a timestamp comment so anyone checking the status can see when it was last updated.
This will let people avoid sending CR requests to someone who says they are online, but last updated their status a week ago
You need an "online / offline" status column next to the user names on each of the buying & selling tabs. Users update this for themselves, but you can add a script to the spreadsheet that will insert a timestamp comment so anyone checking the status can see when it was last updated.
This will let people avoid sending CR requests to someone who says they are online, but last updated their status a week ago
@vihuff
You need an "online / offline" status column next to the user names on each of the buying & selling tabs. Users update this for themselves, but you can add a script to the spreadsheet that will insert a timestamp comment so anyone checking the status can see when it was last updated.
This will let people avoid sending CR requests to someone who says they are online, but last updated their status a week ago
You need an "online / offline" status column next to the user names on each of the buying & selling tabs. Users update this for themselves, but you can add a script to the spreadsheet that will insert a timestamp comment so anyone checking the status can see when it was last updated.
This will let people avoid sending CR requests to someone who says they are online, but last updated their status a week ago
