Pricing Guide PS4 NA

bryanhaas

I make no warranties express or implied regarding the preceeding or following statements....

So this is the price list I use and modify as stuff I sell well sells or doesn't. If it helps great if not well I don't really care

I do say that in the nicest way possible.

https://docs.google.com/spreadsheets/d/1FTV7ACtmEpQQwsEiHVcrBxC0zKaj6LKvc3An7dGG2t0/edit#gid=1351161011

Newest Price list: https://docs.google.com/spreadsheets/d/1FTV7ACtmEpQQwsEiHVcrBxC0zKaj6LKvc3An7dGG2t0/edit?usp=sharing

bryanhaas

bryanhaas wrote: »

I make no warranties express or implied regarding the preceeding or following statements....

So this is the price list I use and modify as stuff I sell well sells or doesn't. If it helps great if not well I don't really care

I do say that in the nicest way possible.

https://docs.google.com/spreadsheets/d/1FTV7ACtmEpQQwsEiHVcrBxC0zKaj6LKvc3An7dGG2t0/edit#gid=1351161011

Btw the prices in black are filler to get to a starting point while the ones in red are actual sales.

davey1107

That's impressive. Confusing for someone outside your trade empire, lol, but impressive.

bryanhaas

davey1107 wrote: »

That's impressive. Confusing for someone outside your trade empire, lol, but impressive.

Trade empire, I like the sound of that.

the_man_of_steal

bryanhaas wrote: »

I make no warranties express or implied regarding the preceeding or following statements....

So this is the price list I use and modify as stuff I sell well sells or doesn't. If it helps great if not well I don't really care

I do say that in the nicest way possible.

https://docs.google.com/spreadsheets/d/1FTV7ACtmEpQQwsEiHVcrBxC0zKaj6LKvc3An7dGG2t0/edit?usp=sharing

WOW YOU ARE INSANE for doing something like this!!!!

INSANELY AWESOME! When did you start documenting these sales!?! and how do you even get this data!?!

bryanhaas

the_man_of_steal wrote: »

bryanhaas wrote: »

I make no warranties express or implied regarding the preceeding or following statements....

So this is the price list I use and modify as stuff I sell well sells or doesn't. If it helps great if not well I don't really care

I do say that in the nicest way possible.

https://docs.google.com/spreadsheets/d/1FTV7ACtmEpQQwsEiHVcrBxC0zKaj6LKvc3An7dGG2t0/edit?usp=sharing

WOW YOU ARE INSANE for doing something like this!!!!

INSANELY AWESOME! When did you start documenting these sales!?! and how do you even get this data!?!

I get it from my own sales, now I wouldn't say it is 100 percent but as I update it the accuracy will also improve.

bryanhaas

Here is a public modifiable version. https://docs.google.com/spreadsheets/d/1PBMN8Ki-JT9gTZ8NHafyEzMrKaFcDIwDHXOlZ9_mBEA/edit?usp=sharing

bryanhaas

Updated.

https://docs.google.com/spreadsheets/d/1FTV7ACtmEpQQwsEiHVcrBxC0zKaj6LKvc3An7dGG2t0/edit#gid=1351161011

Uberdogger

That is crazy awesome! Thanks for posting it--saves potentially hours of trolling traders. Are these prices mostly what you got from using guild traders?

bryanhaas

Uberdogger wrote: »

That is crazy awesome! Thanks for posting it--saves potentially hours of trolling traders. Are these prices mostly what you got from using guild traders?

Yes, it continues to be updated so the accuracy should continue to increase.

Brockstarr2113

So.. I might be an idiot, but... whats the difference between price and stack cost? Which number are you listing these things at? Thanks!

JUSTIN_giver

Brockstarr2113 wrote: »

So.. I might be an idiot, but... whats the difference between price and stack cost? Which number are you listing these things at? Thanks!

@ brockstarr2113 I believe the stack is how many sold, the price was per item.

JUSTIN_giver

@Brockstarr2113 I believe the stack is how many sold and the price was per item.

bryanhaas

Brockstarr2113 wrote: »

So.. I might be an idiot, but... whats the difference between price and stack cost? Which number are you listing these things at? Thanks!

There are no stupid questions just stupid people.

I kid I kid, just wanted to use that South Park line.

Price is each and stack is how many I sell at a time. The last sold is how much I receive after it sells. The price and price per stack averages the last sold prices and increases the price by a set percentage. If an item does not sell then it gets a zero lowering the overall average until it does sell. Once it does sell I remove the zeros but enter the last sold price, once I feel sufficient history has been recorded I wipe the older history so that the averages reflect current pricing trends of the market.

If you guys notice my price on something is out of whack lmk and if I agree I will make the changes. Also I could make a public editable version kinda crowd sourced pricing data however trolls, all the trolls.

Anyways any other questions lmk, and if I am taking my sweet time in getting back send me a message on PSN or in my PSN community.

Thanks.

Brockstarr2113

I'm still just curious as to the "cost" column. Like in the motifs theres the price - stack - total - cost columns. Same with enchanting and trait stones.

If I've gathered the information from you right, last sold is what you've received after selling it (its whatever you get after house cut and listing fee)

bryanhaas

Brockstarr2113 wrote: »

I'm still just curious as to the "cost" column. Like in the motifs theres the price - stack - total - cost columns. Same with enchanting and trait stones.

If I've gathered the information from you right, last sold is what you've received after selling it (its whatever you get after house cut and listing fee)

Cost was what I was willing to buy for but it was skewed due to the multiplication on the average so I have since removed it. Or at least it should now be removed. If you still see it lmk and I will look at it again.

bryanhaas

Brockstarr2113 wrote: »

I'm still just curious as to the "cost" column. Like in the motifs theres the price - stack - total - cost columns. Same with enchanting and trait stones.

If I've gathered the information from you right, last sold is what you've received after selling it (its whatever you get after house cut and listing fee)

On last sold that is correct. Also I sell only in guild traders.

Brockstarr2113

Yeah it was on a few of them on the public modifiable version, and updated one from the 27th. Been using your spreadsheet for a few days and so far so good haha

bryanhaas

Brockstarr2113 wrote: »

Yeah it was on a few of them on the public modifiable version, and updated one from the 27th. Been using your spreadsheet for a few days and so far so good haha

I haven't really touched the public modifiable one really as no one really mentioned one way or the other whether it was useful. It would be great if a bunch of people took it upon themselves to start filling in prices on the public one though.

bryanhaas

I have begun using the online version solely lately so pricing is being updated more frequently now. I usually resort about once a week so the most expensive items are near the top.

bryanhaas

Anyone know if there is a way to import an excel macro into a google sheet or is it a completely different language?

I have this I was trying to add into the google doc for pricing:

Sub Sort_All()
' Sort_All Macro
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.AutoFilter
Selection.AutoFilter
ActiveWorkbook.Worksheets("Alchemy").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Alchemy").AutoFilter.Sort.SortFields.Add Key:= _
Range("CA1"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Alchemy").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Sheets("Material").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.AutoFilter
Selection.AutoFilter
ActiveWorkbook.Worksheets("Material").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Material").AutoFilter.Sort.SortFields.Add Key:= _
Range("CA1"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Material").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Sheets("Trait Stones").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.AutoFilter
Selection.AutoFilter
ActiveWorkbook.Worksheets("Trait Stones").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Trait Stones").AutoFilter.Sort.SortFields.Add Key _
:=Range("CA1"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption _
:=xlSortNormal
With ActiveWorkbook.Worksheets("Trait Stones").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Sheets("Enchanting").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.AutoFilter
Selection.AutoFilter
ActiveWorkbook.Worksheets("Enchanting").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Enchanting").AutoFilter.Sort.SortFields.Add Key:= _
Range("CA1"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Enchanting").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Sheets("Provisionong").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.AutoFilter
Selection.AutoFilter
ActiveWorkbook.Worksheets("Provisionong").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Provisionong").AutoFilter.Sort.SortFields.Add Key _
:=Range("CA1"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption _
:=xlSortNormal
With ActiveWorkbook.Worksheets("Provisionong").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Sheets("Motifs").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.AutoFilter
Selection.AutoFilter
ActiveWorkbook.Worksheets("Motifs").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Motifs").AutoFilter.Sort.SortFields.Add Key:=Range _
("CA1"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Motifs").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Sheets("Style Mats").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.AutoFilter
Selection.AutoFilter
ActiveWorkbook.Worksheets("Style Mats").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Style Mats").AutoFilter.Sort.SortFields.Add Key:= _
Range("CA1"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Style Mats").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Sheets("Supplies").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.AutoFilter
Selection.AutoFilter
ActiveWorkbook.Worksheets("Supplies").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Supplies").AutoFilter.Sort.SortFields.Add Key:= _
Range("CA1"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Supplies").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Sheets("Crafted Food and Drink").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.AutoFilter
Selection.AutoFilter
ActiveWorkbook.Worksheets("Crafted Food and Drink").AutoFilter.Sort.SortFields. _
Clear
ActiveWorkbook.Worksheets("Crafted Food and Drink").AutoFilter.Sort.SortFields. _
Add Key:=Range("CA1"), SortOn:=xlSortOnValues, Order:=xlDescending, _
DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Crafted Food and Drink").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Cells.Select
Range("A2").Activate
Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"
Selection.Columns.AutoFit
Range("F2").Select
Range("A2").Select
Sheets("Supplies").Select
Cells.Select
Range("A2").Activate
Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"
Selection.Columns.AutoFit
Cells.Select
Range("A2").Activate
Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"
Selection.Columns.AutoFit
Range("E2").Select
Range("A2").Select
Sheets("Style Mats").Select
Cells.Select
Range("A2").Activate
Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"
Selection.Columns.AutoFit
Range("E2").Select
Range("A2").Select
Sheets("Motifs").Select
Cells.Select
Range("A2").Activate
Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"
Selection.Columns.AutoFit
Range("C2").Select
Range("A2").Select
Sheets("Provisionong").Select
Cells.Select
Range("A2").Activate
Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"
Selection.Columns.AutoFit
Range("E2").Select
Range("A2").Select
Sheets("Enchanting").Select
Cells.Select
Range("A2").Activate
Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"
Selection.Columns.AutoFit
Range("E2").Select
Range("A2").Select
Sheets("Trait Stones").Select
Cells.Select
Range("A2").Activate
Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"
Selection.Columns.AutoFit
Range("E2").Select
Range("A2").Select
Sheets("Material").Select
Cells.Select
Range("A2").Activate
Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"
Selection.Columns.AutoFit
Range("E2").Select
Range("A2").Select
Sheets("Alchemy").Select
Cells.Select
Range("A2").Activate
Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)"
Selection.Columns.AutoFit
Range("E2").Select
Range("A2").Select
End Sub

bryanhaas

Just a pretty basic macro to automate sorting and a few other things, but if I have rewrite it in Google"s format I may just go back to using excel and uploading once a week.

bryanhaas

I should have an update to the prices tonight, I have redone some of the calculations for figuring how much to charge based on the average price. There is also an average price in field CA, it starts in CA1 and extends based on how many items are in that sheet. So it might be CA1 to CA36, I am using the row number to calculate the additional amount to charge so that items in lower demand increase faster and items in high demand will increase slower. So an item on row 36 would be priced: 500 gold average sell and then the multiplier (36/10 = 3.6) 500 x 3.6 so a sell of 1800. An item in row 2 with an average of 10,000 would be 12,000. All sorting is done by the average price, also by having both hopefully it should be helpful to give an an idea of a range of prices to use and prevent under pricing slow moving items.

WarpigFunk

Celestial sells that high? **** ... I've been selling those pages for like 8k. No wonder they sell immediately lol.

bryanhaas

WarpigFunk wrote: »

Celestial sells that high? **** ... I've been selling those pages for like 8k. No wonder they sell immediately lol.

Yes I can definitely guarantee it does, I think I sold a page the other day for 32k.

Those provisioning mats though are a gold mine, go into zone chat and offer to buy any stacks of prov. mats for 1k then turn around and sell them in a store for 5k to 15k per 25. What is that 1,000 percent profit?

bryanhaas

I have just updated this morning. I am also willing to accept confirmed sales data to add to it the sheet.

TamrielSaviour215

Is this a trading guild on ps4? I have so many things to trade and the guild that I am in does not really do what I need. Id love to join that guild if that's legit. You are the man.

bryanhaas

TamrielSaviour215 wrote: »

Is this a trading guild on ps4? I have so many things to trade and the guild that I am in does not really do what I need. Id love to join that guild if that's legit. You are the man.

I have a small trading guild on PS4. What are you looking for exactly? If I cannot provide it I know of many who likely can.

TamrielSaviour215

I have a small trading guild on PS4. What are you looking for exactly? If I cannot provide it I know of many who likely can.[/quote]

I am looking for weapons/armor that I still need to research. Cant find a lot of the woodworking items that no one in my guild has available. I also have a lot of materials, ingredients, recipes, motifs, etc.. that no one buys. Just looking to make some gold and keep the trading going.

bryanhaas

TamrielSaviour215 wrote: »

I have a small trading guild on PS4. What are you looking for exactly? If I cannot provide it I know of many who likely can.

I am looking for weapons/armor that I still need to research. Cant find a lot of the woodworking items that no one in my guild has available. I also have a lot of materials, ingredients, recipes, motifs, etc.. that no one buys. Just looking to make some gold and keep the trading going.

[/quote]

Sounds like you are not looking for a top tier (10k per week trader) probably low cost for buying here and there. My guild might be a good fit currently. Some other guild stores to visit are Back Alley trading, AFK, Eath Station and IMAG. I list items in those fairly frequently usually things like ebony cotton you know all the hard to find stuff that no one sells. It may not be cheap but it is available. People buy 25 pcs. of cotton for 7,500 to 12,000, boggles my mind that it occurs. Message me on PSN bryanhaas

TamrielSaviour215

bryanhaas wrote: »

TamrielSaviour215 wrote: »

I have a small trading guild on PS4. What are you looking for exactly? If I cannot provide it I know of many who likely can.

I am looking for weapons/armor that I still need to research. Cant find a lot of the woodworking items that no one in my guild has available. I also have a lot of materials, ingredients, recipes, motifs, etc.. that no one buys. Just looking to make some gold and keep the trading going.

Sounds like you are not looking for a top tier (10k per week trader) probably low cost for buying here and there. My guild might be a good fit currently. Some other guild stores to visit are Back Alley trading, AFK, Eath Station and IMAG. I list items in those fairly frequently usually things like ebony cotton you know all the hard to find stuff that no one sells. It may not be cheap but it is available. People buy 25 pcs. of cotton for 7,500 to 12,000, boggles my mind that it occurs. Message me on PSN bryanhaas [/quote]

Dude, you are the man. I will definitely check that out soon. I've been looking for ways to get deeper into the game and this might just do it.