DEVTOME.COM HOSTING COSTS HAVE BEGUN TO EXCEED 115$ MONTHLY. THE ADMINISTRATION IS NO LONGER ABLE TO HANDLE THE COST WITHOUT ASSISTANCE DUE TO THE RISING COST. THIS HAS BEEN OCCURRING FOR ALMOST A YEAR, BUT WE HAVE BEEN HANDLING IT FROM OUR OWN POCKETS. HOWEVER, WITH LITERALLY NO DONATIONS FOR THE PAST 2+ YEARS IT HAS DEPLETED THE BUDGET IN SHORT ORDER WITH THE INCREASE IN ACTIVITY ON THE SITE IN THE PAST 6 MONTHS. OUR CPU USAGE HAS BECOME TOO HIGH TO REMAIN ON A REASONABLE COSTING PLAN THAT WE COULD MAINTAIN. IF YOU WOULD LIKE TO SUPPORT THE DEVTOME PROJECT AND KEEP THE SITE UP/ALIVE PLEASE DONATE (EVEN IF ITS A SATOSHI) TO OUR DEVCOIN 1M4PCuMXvpWX6LHPkBEf3LJ2z1boZv4EQa OR OUR BTC WALLET 16eqEcqfw4zHUh2znvMcmRzGVwCn7CJLxR TO ALLOW US TO AFFORD THE HOSTING.

THE DEVCOIN AND DEVTOME PROJECTS ARE BOTH VERY IMPORTANT TO THE COMMUNITY. PLEASE CONTRIBUTE TO ITS FURTHER SUCCESS FOR ANOTHER 5 OR MORE YEARS!

I've been playing with Excel and importing various exchange information into them so I can determine good arbitrage possibilities.

One solution I finally settled on is as follows:

  1. In Excel (I use the most recent Office) click on Data on the toolbar.
  2. On the left, click “From Web” and enter the URL of an exchange. I've not been able to import some sites, like Coinex (no DVC, but a good example) and mcxNOW (now dead to DVC). Every other DVC exchange that I know of works fine (cryptsy, crypto-trade, cryptocoincharts, vircurex). Cycle through the prompts you're given.
  3. To organize, choose an empty cell and use the following formulas:
  • a. To retrieve the ticker symbol ”=LEFT(Cryptsy!A15,3)” [LEFT tells Excel to start from the left of the cell in tab “Cryptsy” starting in cell A15 and responds with the first 3 characters.]
  • b. To retrieve text from the middle ”=MID('BTC-e'!A24,5,3)” [Here I'm reading a mid character, from sheet BTC-e, cell A24, starting with the 5th digit, returning 3 characters. BTC-e data pulls differently than Cryptsy and Coinex.]
  • c. To retrieve the last price ”=RIGHT(Cryptsy!A15,10)” [Returns the leftmost 10 characters.]

This first image is the raw data from an import of Coins-e information. But in order to use comparisons, we have to split the information into separate cells.

i.imgur.com_v8mjgde.jpg

This screenshot shows BTC-e data after I've split it using the formulas described above. Much easier to work with!

i.imgur.com_7rwjano.jpg

After adding the formulas, cut and paste them into a different tab. I just created tabs for the exchanges and then BTC, LTC, DVC, etc. The reason is that when you refresh your data, anything else on that sheet will be purged. So that's why you see my examples above with tab names instead of just cell names.

After doing the above steps, you can see all the prices in a convenient location representing the different exchanges at a glance. You can set refresh to auto or manual. You *can* save it as an html or pdf output, but it won't keep your formulas.

Let me know, or update this wiki, if you are able to determine more helpful guidance.


Author Page


Software


QR Code
QR Code devcoin_prices_ms_excel (generated for current page)
 

Advertise with Anonymous Ads