I've created an online ticker-type website for devcoin against the dollar for the chart bounty.
18 shares for a chart which shows the price of devcoins in USD. The chart should show prices from at least 3 months in the past.
http://dvcticker.bugs3.com/I am wondering how I can automatically create a javascript chart or excel file to record the prices hourly or daily. (e.g. the chart automatically updates each hour based on site data) I will give 5 shares from the bounty if you can assist me! (maybe more, too!)
Funny timing...I've been playing with Excel and importing various exchange information into them so I can determine a good arb.
One solution:
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.]
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 if I need to clarify anything.