All errors and warningsĪre printed to the terminal and fail silently in the UI. Without starting Gnumeric from the command line. Warning and error messages are not displayed There is currently no way to know what is happening inside the plugin ![]() The "Edit" menu, or by simply pressing F9. This can be done by selecting "Recalculate" from Limitations Other worksheets may not update automatically after refreshing Whenever you update the GW2Spidy data, you will likely need to manually The item ID can be found by looking at the end of an item URL on Other information will be fetched from GW2Spidy automatically the next time you GW2Spidy item IDs into the data_id column of your Spidy table, and the Once you have your spidy_col() columns set-up, all you have to do is input This will fetch the base virtual machine for developing (a Ubuntu Precise 64bit server), install all of the required packages, configure mysql and nginx, then forward the virtual machine's port 80 to your machine's port 8080. Predefined columns you can take a look at. Once you have this, simply cd into the gw2spidy directory and run vagrant up. When this plugin creates a new "Spidy sheet" for you, it will have some That will be displayed in the cell, and field, which corresponds to an itemĭata field in a GW2Spidy Item Data API response dictionary. Is called with two string arguments: display, which is simply the text The column headers use a special function called spidy_col(str,str) which Menu will create an empty "Spidy sheet" for you if it does not exist. Using the "Update GW2Spidy Data" command in the "Data -> Get External Data" To get started using this GW2Spidy plugin with your spreadsheet, a special Just drop the spidy/ folder in your Gnumeric plugins directory ,Įnable it in the Gnumeric plugins interface, and there you go. Item data from the GW2Spidy web API and store it in a specially named andįormatted sheet for use in your calculations. This Python plugin for Gnumeric provides a way to fetch Guild Wars 2 It's pretty close and still useful, but can lead you astray if you aren't careful.GW2Spidy Plugin for Gnumeric So, what is this? It's important to remember that websites like gw2spidy don't track "true" supply and demand. This usually means the item is dominated by people playing the TP and nobody is using fast sell. I have 4 different items this week I've been successfully flipping for between an 800 and 950% return.ĭon't put buy orders on items where the demand drastically outnumbers the supply (active buy orders versus sell orders). This is if you're even lucky enough to get a successful buy order.įind niche markets and keep them secret. The increased demand these websites add to the items (buy order competition) quickly outpaces the sell prices and the items lose their profitability. At any one time I usually have around 100g tied up in buy orders and investments.Īvoid the top margin items on and gw2spidy because EVERYBODY sees them and the competition is crazy. ![]() Supplement with high volume (5000+) purchases on cheap items and flip for ~20% return. Diversify between the different item types. I'd say from my limited experience you probably successfully get about 10% of your buy orders. Update: I have updated my old github page on the project to v1.3, feel free to branch it and add to it, thanks /u/x4hx_Famine Surprisingly, my low budget site did not fail under the influx of Redditors (700 of ye so far) but the Google sheets did. Spreadsheet direct link: (removed, Reddit Hugged it to death) This is the barrier I want to remove for new creators, I have created a fairly hassle free script with good (almost foolproof) instructions. Both learning Javascript and how the script worked (to be fair he had some really good comments in the code) were the two main reasons why it was so slow for me to improve upon it. While his script was a good baseline it was fairly limited, it can only load one category of item at a time. However I only really got into it when I wanted a better version of EggBaron's sheet. What has prompted me to release this is EggBaron's post a few days ago, it got me thinking that if the scripting is easier to access and use then more people would be able to create their own sheets to their liking and in general make this small ecosphere that much richer (literally and figuratively).Ī few of you may know me as the person who has done a few spreadsheets about the tradepost/gemstore.
0 Comments
Leave a Reply. |