tag:blogger.com,1999:blog-8558011570345628688.post3296008455366370924..comments2023-10-01T11:14:14.368-04:00Comments on The Egg Baron: Skill Points to Gold Spreadsheet UpdatePhilhttp://www.blogger.com/profile/06525149260217843564noreply@blogger.comBlogger28125tag:blogger.com,1999:blog-8558011570345628688.post-75173496428130450542020-07-01T07:24:58.542-04:002020-07-01T07:24:58.542-04:00If someone needs more gold, I recommend buying it....If someone needs more gold, I recommend buying it. Currently, gold prices are really low. This site <a href="https://mmogoldprice.com/game/guild-wars-2" rel="nofollow">https://mmogoldprice.com/game/guild-wars-2</a> will allow you to easily find the cheapest offer from a trusted seller.richardwa195https://www.blogger.com/profile/02756545165245017727noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-22987863485441059442015-05-02T10:04:05.024-04:002015-05-02T10:04:05.024-04:00This comment has been removed by the author.InfraMousehttps://www.blogger.com/profile/07047905895173388261noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-70533275957057031292014-02-09T12:19:39.041-05:002014-02-09T12:19:39.041-05:00It has been a while since I have looked at that co...It has been a while since I have looked at that code, but my guess is that you need to make a modification to line Line 87 and Line 81.<br /><br />I only pull in the crafting materials data in my code.<br /><br />You may need to pull in more data by modifying the category here.<br /><br />See the documentation for the Spidy API here: https://github.com/rubensayshi/gw2spidy/wiki/API-v0.9#wiki-full-item-list<br /><br />Oh and here are the different "top level types". Only the bolded words count, like Armor, Bag, Consumable. http://www.gw2spidy.com/types<br /><br />I hope that helps.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-88353424025660162332014-02-09T09:39:53.681-05:002014-02-09T09:39:53.681-05:00Hey Phil, thanks alot for the awesome script. :)
...Hey Phil, thanks alot for the awesome script. :)<br /><br />I decided to try my hand at making a sheet of my own, based on yours. But I can't seem to get the script to fetch data from other IDs than the ones already there.<br />Whenever I add another ID (example: 44969) I get the Error: ID not in cache. I've been trying for well over an hour, and updating doesnt seem to fix it.<br /><br />I'm no good with code, but if you could help me out I'd be grateful!Anonymoushttps://www.blogger.com/profile/07541812486188214256noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-5306367689278127522014-01-31T16:44:04.096-05:002014-01-31T16:44:04.096-05:00Still a great sheet.. Thanks again!!!Still a great sheet.. Thanks again!!!Anonymoushttps://www.blogger.com/profile/17483880277017063990noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-12071768659489644272013-10-27T17:24:51.887-04:002013-10-27T17:24:51.887-04:00Help! I would really like to see the best way to t...Help! I would really like to see the best way to turn skill points into gold, but the spreadsheet is no longer live. Is there a way to turn it back on? Melissa Runninghttps://www.blogger.com/profile/17533064046110313400noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-50957269894798197392013-07-14T15:07:54.827-04:002013-07-14T15:07:54.827-04:00I'd love to see this updated again, thanks for...I'd love to see this updated again, thanks for the initial hard work though ~Anonymoushttps://www.blogger.com/profile/04054776577278594437noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-71020033692069004972013-07-10T04:45:14.664-04:002013-07-10T04:45:14.664-04:00I think your script is fetching the data for the h...I think your script is fetching the data for the highest offer not the lowest sales price. Can you check?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-91010939347955281422013-03-14T08:48:51.891-04:002013-03-14T08:48:51.891-04:00One comment on the spreadsheet details - it shows ...One comment on the spreadsheet details - it shows Trading Post fees at 15% - but my understanding is that they are 10% - 5% listing fee and a further 5% when sold.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-87066003385061750982013-02-22T20:02:08.121-05:002013-02-22T20:02:08.121-05:00I've heard that the downvoting on Reddit happe...I've heard that the downvoting on Reddit happens to keep things more secretive, especially with market stuff -> the fewer people that know about it the longer the profits stay viable.<br /><br />Great work on the new sheet, too. I really like being able to see both the simplified and complex breakdowns of the transmutations.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-36847776399385634632013-02-18T17:08:09.447-05:002013-02-18T17:08:09.447-05:00I am not sure what the limit on the URLFetch is, e...I am not sure what the limit on the URLFetch is, either way that is on Google's side. I used to run my spreadsheet with "...all-item/all". I never ran into the URLFetch problem, but occasionally I would get a time out which could then put bad data into the cache. Thus, my guess it is a number of uses thing. I know I read somewhere that Google was trying to increase the time and the number of uses allowed with URLFetch.<br /><br />I was thinking of expanding the caching script to go through each item type one by one to populate the cache. It wouldn't be difficult to do, then it could grab all the items without timeouts.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-40821529679023280002013-02-18T11:57:19.845-05:002013-02-18T11:57:19.845-05:00yeah i like your caching solution and decided to m...yeah i like your caching solution and decided to make my scripts around it. Though now i hit the daily urlfetch quota. I don't know if it is the data size quota per day is reached or the amount of querries. <br />Anyway i will reduce my traffic by making a central spreadsheet that fetches the data of all my items with your script. <br />Other spreadsheets will import the raw data with Importrange().<br />This way i can make as many tradepost spreadsheets as i want and they will all share the same data.<br /><br />Will just have to find out if the central spreadsheet hits the quota, if it uses .../all-items/allAnonymoushttps://www.blogger.com/profile/07845315065965287254noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-83032841357543828842013-02-17T21:37:11.516-05:002013-02-17T21:37:11.516-05:00Heh, funny with Reddit isn't it? I posted my s...Heh, funny with Reddit isn't it? I posted my sheet to reddit too and got quite a few down votes. Now I see someone has reposted my sheet again, and it got down voted right off the main page. But still, there are like 20+ people constantly on the sheet viewing it.<br /><br />I like your sheets. They remind me of how I originally handled data from GW2Spidy, but like you say you run into limitations. Still you have some good data there. I also like you calculate the number of higher materials needed to profit. That is a smart way to look at the profitability of these promotions that I did not think of.<br /><br />My script can handle all the items from GW2Spidy and dump the data into a spreadsheet although it will occasionally timeout. I hope to have a tutorial up in the next week or two describing how to use my script to build a spreadsheet with live GW2Spidy data.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-82660949814882013212013-02-17T13:08:39.259-05:002013-02-17T13:08:39.259-05:00if it helps yous ave some time, here is my spreads...if it helps yous ave some time, here is my spreadsheet for common materials<br />https://docs.google.com/spreadsheet/ccc?key=0AmM8m4-QrjIDdHFueDRBUXNOMy1uLVpGamtMZktqb3c&usp=sharing<br /><br />i never used common material promotion though, since i used t1->t2 fine promotion. <br />Here are my other two sheets i made:<br />https://docs.google.com/spreadsheet/ccc?key=0AmM8m4-QrjIDdF9mVVdzYVRickVheHo0UmRlemRVTkE&usp=sharing<br /><br />https://docs.google.com/spreadsheet/ccc?key=0AmM8m4-QrjIDdE9ZNVJqNmJ1ZklEZDRJWjl1YUk4dnc&usp=sharing<br /><br /><br />though your sheets are way better and avoid the errors that are bound to happen on long item lists, because of google spreadsheets limitations.<br /><br />I might look into your method, for my other spreadsheets...right now i am looking into other areas.<br /><br />I posted my spreadsheets above on reddit some weeks ago and got downvoted pretty fast (funny though since there have constantly been users on my sheets since then...especially the fine promotion oneAnonymoushttps://www.blogger.com/profile/07845315065965287254noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-27750844738654307512013-02-13T19:19:14.259-05:002013-02-13T19:19:14.259-05:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-71491401173292518702013-02-05T08:15:27.042-05:002013-02-05T08:15:27.042-05:00That occasionally happens if GW2Spidy fails to res...That occasionally happens if GW2Spidy fails to respond to my scripts request with the correct data. The cache then gets filled with blanks which are updated to the spreadsheet. This is normal fixed in the next update which will occur 10 minutes later.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-57031143615844353102013-02-05T02:58:13.282-05:002013-02-05T02:58:13.282-05:00I am very sorry, I ment the FINE crafting material...I am very sorry, I ment the FINE crafting materials, (venom sac, blood, scales..etc) Sorry for that, I got all the names mess up. :/<br /><br />Try tiny venom sac into small venom sac promotion.<br /><br />ZoKCsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-83993027871272065842013-02-05T02:21:55.969-05:002013-02-05T02:21:55.969-05:00When I try to open the spread sheet I get error ID...When I try to open the spread sheet I get error ID not in cache can anyone help me out?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-46198765337428567832013-02-04T14:20:19.496-05:002013-02-04T14:20:19.496-05:00Try tiny venom sac ;)Try tiny venom sac ;)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-16767701113710339232013-02-04T13:31:14.878-05:002013-02-04T13:31:14.878-05:00FYI Copper -> Iron is not a profitable example....FYI Copper -> Iron is not a profitable example.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-46365123115073514132013-02-04T13:30:23.392-05:002013-02-04T13:30:23.392-05:00I did some preliminary tests that look promising. ...I did some preliminary tests that look promising. Still need to test more to determine the answers to these questions.<br /><br />1) How many materials does promoting T1-T2 give?<br />2) Is this the same as for T2-T3? T3-T4? T4-T5? (I know T5-T6 is different is this the only one?)<br /><br />My first tests I just did 1000 Copper Ore to Iron Ore. For the four tries it took I got 60, 60, 61, and 63 Iron Ore for 250 Copper. <br /><br />So, just from that, as a general rule of thumb, look for T2 materials that you can sell for at least 4 times what you buy the T1 material for. Whether this carries on for the other tiers IDK. <br /><br />I will try testing T4-T5 next, if that holds I think it is same to assume it is the same of the other tiers. I will do that tomorrow.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-2549302415124023192013-02-04T12:58:54.390-05:002013-02-04T12:58:54.390-05:00Wow T1 to T2 common crafting mats make that much?!...Wow T1 to T2 common crafting mats make that much?! <br />Time to hit the math on those, that really sounds promissing :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-60540687022316412112013-02-04T11:32:32.916-05:002013-02-04T11:32:32.916-05:00Thank you for taking the time answering ;)
You ar...Thank you for taking the time answering ;)<br /><br />You are absolutly right, with the excitment of this new version I read to fast and overlooked the detailed version, thats great! excellent work! Thank you very much!<br /><br />Looking foward to it =)<br /><br />ZocksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-39432256616585041622013-02-04T11:27:02.343-05:002013-02-04T11:27:02.343-05:00Wow I will have to add that in. Also, you can stil...Wow I will have to add that in. Also, you can still access the more details view via the tabs at the bottom of the screen. You should see a "simplified view" "detailed view" "raw data" and "logs".<br /><br />Thanks for taking the time to comment! I will look into adding the rest of the common materials.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-3597775473738711342013-02-04T11:25:13.690-05:002013-02-04T11:25:13.690-05:00I ment t1 to t2 common crafting materials.
ZoCksI ment t1 to t2 common crafting materials.<br /><br />ZoCksAnonymousnoreply@blogger.com