That is actually a very helpful material spreadsheet but the shard prices are going to be harder than that to find out every day. If one person puts up 50green shards at 20crowns each then its not an accurate way to measure buy the cheapest.

Nice work on gathering all that data!

May I ask how you got the material prices though?

It seems rather difficult to find the final selling price so did you do it by buy price per unit?

for some stupid reason my internet providers blocked tinyurl.com so i had to use TOR and was tired of not having the ability to shift+tab with steam and enter the spread sheet so i made a tiny.cc url its: http://tiny.cc/SKspreadsheet also i am not gaining ANYTHING from this im just posting it out there for other people.
also keep up the good work.
thanks

because its not actually my internet provider its my country that blocked it

You must've worked really hard to get it done.

You can read about standard deviation here.
Excel has a function that does the actual calculations.

Nice work here. Were you going to use this to forecast prices in the future? If so, maybe we can use some simple moving averages or something but then our limit would be to how many days or weeks you have in the spreadsheet so far. Not that they may be particularly useful or accurate or even necessary, maybe just another way to keep track of price movement and buy items and such. Or to link it with ce prices or even other popular items, but that's probably done with time series stuff and even that may be more unnecessary. I'm not sure if stock prices or prices for any good for that matter is one of those that does not fall into a normal distribution, but then again that's probably for other complex stuff like quality control and so forth. Anyways, this is good data to look and refer to and applicable anyhow. Thanks.

As someone who's made a virtual career of buying and selling materials amongst other things this is a good starting point. Prices do swing quite widely periodically (beyond a month) and can even vary considerably through the day based on the active time zones. The timezone you place the bid in should determine how much you undercut the buy-now price, but sometimes it pays to hang onto the material for an extra day or two in case the prices swing up. A guide like this, and notes you keep can help determine whether it's worth selling now.

Some additional tips: When placing materials on the market, the qty you place will affect how sellable it is. For rage-craft materials (shards, bones, fangs, scales,...) you can put materials up in larger batches. (i.e. 10 or more) For less commonly used materials, it helps to sell them in units of 1, 2 or 3 depending on what the crafting requirements that recipes typically call for. For example, If the cheapest price for a material is a batch of 10 or more for 150/unit, and the next lowest price for singles was 200/unit then you can easily list singles/small batches at 175-190/unit and they will generally sell.

For less commonly used materials, avoid the temptation of listing a large number at once even as separate bids. Once undercut you have to wait until all the lower priced ones sell. If only a few are bought a day, you will easily find that one or two sell, and the rest are returned. Larger demand materials (common rage-craft materials)

I find for materials, a listing time of 12hrs works well. The longer you list, the more visibility the material has, but if you list price is too high it will just cost you more. Just remember that as long as the material sells you get back the listing fee, you just pay 10%. The catch with higher star materials and qty is that the listing price can be quite high so you have to be sure it sells. (Worst case, it helps to use an alt/friend to bid your material to ensure it only costs you the 10% if no serious buyers want it.)

If you have large quantities of materials that you want to sell then the AH will take considerable time. Slapping 100+ materials in a batch will be very expensive with a reasonable bid price and can easily not sell or just sell for the bid price where smaller qty can sell for more. In these cases to get maximum cr, sell small batches over time, or for a faster sale, go direct to players but be prepared to discount at least the 10% listing fee from prices. (I generally look to buy at least 20% off lower AH prices direct when buying mats to supply crafters)