Quote from: hankhill69 on March 26, 2014, 03:31:10 PM

I have asked this question on stack overflow but no one replied so this is my last hope...

"I have created a profitability calculator for alternative currency trading in excel, which does the simple math (adds fees, sub fees etc) for me as a hobby on the website www.cryptsy.com. The problem I am having is I want to learn how would be the best way in this communities opinion to automate ONLY the buy and sell price from the website into my excel sheet? I have been told API would be the best way but I am not sure. Also please keep in mind programming experience is very little but willing to learn everything.

Thank you for your help"

Does this sound good? pretty much I have a calculator in excel i have built and i want to bring only specific data from cryptsy.com into the excel sheet so it is automated at all times and feeding data.

To me it sounds like you're looking for a web query using Excel. You might want to start there if you haven't already.

As a note, you may need to set the web query columns as hidden columns and use a formula to set a different cell equal to the constantly updating cells and assign that copy cell as a different data type.