Have a good Halloween? I ate candy corn. Sorry- typo. I mean I hate
candy corn. Today's Thursday which means it's time for a fresh new
episode of Gold Guru right here on Guild Wars 2 Riches, ShoddyCast's weekly show that hopefully makes you a
little richer. Last week I was contacted over on YouTube by a
delightful GW2 enthusiast by the name of Kornuit. Kornuit saw our other video
about making gold via salvageable bags, and has been hard at work on
the Trading Post. Instead of taking notes with pen and paper, and
instead of having to do math himself, he put together an Excel sheet
that makes playing the Trading Post even more enjoyable. Kornuit has
given me the okay to use this wonderful tool in today's episode, and it
is also his wish that I give you all access to this tool also. What a
nice guy! Everyone say, "thank you Kornuit". Good.
Now let's take this puppy for a spin and test it on a dye flipping strategy that I've been meaning to try.
So despite my original hypothesis, dyes might actually be a legit item for long term flipping on the Trading Post. If you want to test this strategy out for yourself I recommend staying within your price range obviously to limit your risk. Luckily dyes have a massive scope when it comes to price range. I felt more comfortable with the 2-3 silver price range, but if you play more than me and have lots of dough, feel free to explore the higher price tiers.
My Successful Flipping Attempts:
Evergreen Dye x5
Purchase- 1s 3c/ea
Sold- 1s 93c/ea
Profit- 3s 5c - +59.3%
Evening Red Dye x5
Purchase- 1s 18c/ea
Sold- 1s 99c/ea
Profit- 2s 56c - +43.3%
Evening Dye x5
Purchase- 1s 8c/ea
Sold- 1s 87c/ea
Profit- 2s 55c - +47.2%
Wrath Dye x5
Purchase- 2s 71c/ea
Sold- 4s 87c/ea
Profit- 3s 45c - +25.5%
Please be sure and post your own findings and general comments on this strategy below. We love hearing from you. Not really. But yes- we do.
SUBSCRIBE| Join The Forums|
Now let's take this puppy for a spin and test it on a dye flipping strategy that I've been meaning to try.
So despite my original hypothesis, dyes might actually be a legit item for long term flipping on the Trading Post. If you want to test this strategy out for yourself I recommend staying within your price range obviously to limit your risk. Luckily dyes have a massive scope when it comes to price range. I felt more comfortable with the 2-3 silver price range, but if you play more than me and have lots of dough, feel free to explore the higher price tiers.
My Successful Flipping Attempts:
Evergreen Dye x5
Purchase- 1s 3c/ea
Sold- 1s 93c/ea
Profit- 3s 5c - +59.3%
Evening Red Dye x5
Purchase- 1s 18c/ea
Sold- 1s 99c/ea
Profit- 2s 56c - +43.3%
Evening Dye x5
Purchase- 1s 8c/ea
Sold- 1s 87c/ea
Profit- 2s 55c - +47.2%
Wrath Dye x5
Purchase- 2s 71c/ea
Sold- 4s 87c/ea
Profit- 3s 45c - +25.5%
Please be sure and post your own findings and general comments on this strategy below. We love hearing from you. Not really. But yes- we do.
Im very glad my tool is helpful. I've made some adjustments in the past week and I'm thinking about adding a tab for crafting. If anyone else has suggestions for the excel sheet I'm happy to hear them. It's not a very advanced tool, but it helps me to take better decisions. And I'm very happy to give something back to Shoddycast and guildwars2riches since they have helped me so much already.
ReplyDeleteFYI your spreadsheet is semi incompatible with Open Office.
DeleteI just opened it and the 'Min. Price' 'Profit' and "percentage' give me an 'Err:509' message.
If you could update it for OO it would be great!
Sounds great Kornuit. I could see a crafting tab coming in handy. I hope I did your excel sheet some justice in this week's episode. Thanks again for submitting it. I'm sure a lot of people will be messing with it in the weeks to come. It'll be cool to watch it evolve.
DeleteI'v made a version for Open Office, although I can't get the dynamic tables to work (used for making selections and sorting on values etc.)
DeleteI am also working on an improved version including buy/sell times and a small manual on how to use the sheet to it's fullest. I will try to get in contact with guildwars2riches owners when I've completed it.
Your math is wrong. Try again.
DeleteIt's the listing fee whats wrong. It's not a constant value and increases with higher prices or decreases with a higher amount of items. Dunno the actual math for this.
DeleteThe listing fee is always 5%, I made a mistake with the profit calculation, that one is fixed in the new version.
DeleteWhere would one get the updated versions and/or the openoffice version?
DeleteJust curious what the turn around time was on the selling?
ReplyDeleteSure, that can be found in part 2 of the video. It was another 4 hours. In summary, 4 hours to fill the buy order, and 4 hours to flip them in a sell order totaling 8 hours.
DeleteI like this and will be downloading it. Thanks! I think I might add to it a line for date purchased and date sold, just for my own info on how long some things need to sit. Maybe that line wouldn't be important for some though, but I'll be doing more long term flipping than short term.
ReplyDeleteI hear you, I've already added a few little extras to the excel sheet myself, here and there. If you add anything drastic we'd love to see it. Like add Siri to it.
DeleteAs far as dye flipping goes this has been my cornerstone market for a long time. The percentage yield is quite high and time is rate of buy and sell is fairly quick. I went through and bought one of each blue and green dye for my main (placed buy orders only, and they all came in after i went to bed and woke up) and as I did I checked the margin on each. I would place an order for 50-100 if the current sell price was more then double what I could place the buy order for. That is just a easy way for me to confirm the profitablity at a glance as i looked through 500 or so diff items.
ReplyDeleteI came out about 50S ahead and have all the green and blue rarity dyes. Keep in mind i had the funds on hand to place the buy orders (roughly 2ish gold if i recall correctly). This was a few weeks ago but I would guess that the market profit on these hasn't dried up completely yet and that if you want to have more dyes you could still turn a profit.
Do you think that the halloween items are still going to rise? because those hreatsaw greatsword skins are just dropping like hell...
ReplyDeleteAlso the candy corns are on bottom prices...
DeleteTruthfully, they're a limited supply item and there are very few causes for a price drop:
DeleteInvestors offloading;
News indicating a change to their limited status;
Increased number of players online (increase in market supply);
End of event where they were required ("Halloween is over, best get rid of these").
My money is on the last two. After a fall, they'll go up. I'm open to arguments to the contrary of course!
Well this isnt just a little drop though, they were going for 69G a skin and just dropped to 50g. What to do? accept my loss and sell them now or wait hopefully to rise again in price.
DeleteI'm holding onto my Halloween stock for a while yet - how do you feel personally about your investment?
DeleteA lot of the time, investing is a nervous affair but you have to clear out the emotion and work on what the market is telling you.
Logically, do you think this downward trend will continue?
I think since its dropping a bit, people are over-racting and quickly selling their loads on the tp. But this is just my thoughts. the risk of losing 100g on those weapon skins are driving my emotions sane to be honest.
ReplyDeleteyour thoughts?
I think that's pretty much what's going on, a run on the bank. I'd just stay calm and monitor the situation.
DeleteI actually think now is a great time to buy! After a bump that drove prices as speculators purchased there lots the natural end of event bubble burst has occurred.
DeleteAfter speculators pull out of a market because the risk is too high the upward trend stalls. Then as people get itchy to sell we see the trough like right now. Great time to buy, and deff dont sell.
Items that are hot today are likely to still remain in demand as the weeks pass. BLC still give halloween skins until Nov 15. That means supply will continue to increase slowly during that time. The spec bubble that we had was the opportune time to sell if you are looking for a quick turn around. The next spec bubble we will see will be around the 15th as the BLC will no longer give skins, Consumers and speculators alike will probably invest again and that will probably increase the cost again.
Unless you are going for the long spec. (Like assuming Anet will never rerelease these skins again and waiting months or years to sell for a small mint) then you will prob want to moniter prices closer to the actual skins cut off date to see if you can make a significant short term profit
I like your style!
DeleteAlright thanks for the info.
ReplyDeleteHi, can u upload this excel pls
ReplyDelete