|
|
Post by lulu on Feb 20, 2015 3:03:16 GMT -5
Ooh what do you mean about google's motto... I live in a cave as far as current affairs go, what did i miss?
|
|
|
|
Post by wizardnana on Feb 20, 2015 12:43:34 GMT -5
LuLu, I've seen your spreadsheets and formulas and they are brilliant girl!! Crspe, thanx for keeping the market going, you rock! Is it bad that my head hurts from all this formula talk?  ) |
|
|
|
Post by lulu on Feb 20, 2015 16:36:31 GMT -5
Haha nana, you have to embrace your inner geek  |
|
|
|
Post by pigaro on Feb 21, 2015 0:44:22 GMT -5
LuLu - Google has (had?) a corporate motto "Don't be evil." In recent times I would suggest they dropped the word "Don't" from their motto. This article claims that they have dropped their motto, but I am not sure looking at the date of the article. In my opinion they do not live up to their previous motto. |
|
|
|
Post by pigaro on Apr 11, 2015 1:27:53 GMT -5
The price for Lumber seems to be out of sync, at least it is today (4/11/15 UTC). The spreadsheet predicts a price of 105, but the game has 194. All other price predictions are within 1 of the game.
I wonder if this might be one of those cases where the price could be at the opposite end of the prediction?
|
|
|
|
Post by pigaro on Apr 12, 2015 1:35:01 GMT -5
The predicted price for Lumber matches the actual price (120). If you did not buy yesterday (and hopefully you didn't), you should buy today.
|
|
pbtown
Junior Member
Posts: 97 
|
Post by pbtown on May 3, 2015 18:49:26 GMT -5
The prices for commodities seem to be correct however the written recommendations have been in error recently. Check out the prices against others before you buy/sell.
|
|
crspe
New Member
Posts: 11 
|
Post by crspe on May 3, 2015 20:27:03 GMT -5
The price for Lumber seems to be out of sync, at least it is today (4/11/15 UTC). The spreadsheet predicts a price of 105, but the game has 194. All other price predictions are within 1 of the game. I wonder if this might be one of those cases where the price could be at the opposite end of the prediction? Hi Pigaro, Yes, note that when prices are very close to the limits, there is a risk that the price will flip to the other end of the range for that resource. We tried hard to prevent them, but it wasnt possible to eliminate them all. In cases where the prices may be way out, the price estimation in the excel should be highlighted in yellow. In these cases, it can be worth checking the prices in the days before/after to have a contingency plan for what to do if the price is at the opposite end of the scale. (In this case, as you worked out, the best thing to do was to buy on the following day at 120) Chris |
|
crspe
New Member
Posts: 11
|
Post by crspe on May 3, 2015 21:44:19 GMT -5
The prices for commodities seem to be correct however the written recommendations have been in error recently. Check out the prices against others before you buy/sell. Hi Patricia, There are 3 cases that I know of where the recommendations can be wrong. One is that in cases where the profit from a buy/sell cycle would have been very small, the excel recommends that you just hold that resource until there is a better profit possibility. (e.g. the excel suggests that you hold wood on 8,9,10 may. If you want to, you could buy wood on the 8th at 42 and sell it on the 10th at 51, but your profit is pretty small (9 per click, vs the 98 per click that you get for the stone that you bought on 6th may and sold on 8th may). This can be changed in cell C7. If you set it to 0, then the excel will show you every possible buy/sell combination where you should make a profit (of course if the estimated profit is only 1 and the estimations are out by 1 then you may not make a profit). If you change C7 to 0 then you would make about 6% more trading profit, however at a cost of you making about 35% more buy&sell transactions. The second is that the excel takes some days at the start of the sheet to get in sync with the correct buy/sell approach, so if you change the starting date (in cell P8) to be todays date, then the recommendations will be incorrect. This is simple to solve by making sure that the starting day is always at least a couple of weeks in the past, then it should be ok. (i.e. for today I would recommend you set P8 to be 1680 or less) The third is of course when the commodity price recommendation is wrong (see above post in response to pigaro's question) - in these cases the buy/sell recommendation is also incorrect. Watch for the yellow highlighting to see when this is likely to occur. Do any of these cover what you are seeing? if not, please give an example of where the buy/sell recommendation doesnt match what it should and I will look into it. Chris |
|
crspe
New Member
Posts: 11
|
Post by crspe on Jun 21, 2015 21:06:52 GMT -5
I just noticed that the excel that I posted at the start of this thread is coming to the end of its predictions. All you need to do to get predictions until the end of the year is change the number in cell P8 to 1715.
Feel free to try out other numbers to get predictions for dates further ni the past or future.
Happy trading
|
|
pbtown
Junior Member
Posts: 97
|
Post by pbtown on Jun 28, 2015 12:58:37 GMT -5
I am hoping someone knows enough about XP spreadsheet to update the market future for us. I tried and I don't know how to get into cells that aren't visible.
|
|
pbtown
Junior Member
Posts: 97
|
Post by pbtown on Jun 28, 2015 13:44:10 GMT -5
I figured out how to update the spreadsheet. I haven't figured out how to post it here but this is the info for this week.
Market for Monday, June 29 until r17
Wood - sell
Wheat - buy
Rock - hold
Wool - sell
Lumber - buy
Cloth - hold
Stone - sell
Market for Tuesday, June 30, until r17
Wood - buy
Wheat - sell
Rock - hold
Wool - hold
Lumber - sell
Cloth - hold
Stone- hold
Market for Wednesday, July 1, until r17
Wood - hold
Wheat - hold
Rock - buy
Wool - hold
Lumber - buy
Cloth - hold
Stone - hold
Market for Thursday, July 2, until r17
Wood - hold
Wheat - hold
Rock - sell
Wool - hold
Lumber - hold
Cloth - hold
Stone - hold
Market for Friday, July 3, until r17
Wood - sell
Wheat - hold
Rock - hold
Wool - hold
Lumber - hold
Cloth - buy
Stone - buy
Market for Saturday, July 4, until r17
Wood - hold
Wheat - hold
Rock - hold
Wool - hold
Lumber - hold
Cloth - sell
Stone - sell
Market for Sunday, July 5, until r17
Wood - hold
Wheat - hold
Rock - hold
Wool - hold
Lumber - sell
Cloth - hold
Stone - hold
|
|
|
|
Post by pigaro on Jun 30, 2015 2:41:19 GMT -5
|
|
pbtown
Junior Member
Posts: 97
|
Post by pbtown on Jun 30, 2015 14:19:24 GMT -5
I have modified the original file to start with 6/1/15. See attachment. Thank you so much. I only work on an iPad so I couldn't get that part done! Thank you, again! |
|
|
|
Post by pigaro on Jun 30, 2015 22:29:56 GMT -5
You're welcome. I am happy to be able to help.
|
|
)
