Bitcoin Forum
May 22, 2018, 01:06:48 PM *
News: Latest stable version of Bitcoin Core: 0.16.0  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Wanted - bitcoincharts json import to Excel  (Read 1053 times)
ColdHardMetal
Hero Member
*****
Offline Offline

Activity: 700
Merit: 500



View Profile
August 19, 2013, 04:23:14 PM
 #1

I want to be able to import this: http://api.bitcoincharts.com/v1/weighted_prices.json into Excel.

This: http://ramblings.mcpher.com/Home/excelquirks/json apparently explains how to do so.

However, I find I'm missing some basic steps/knowledge. I really have no idea how to make it work and would rather see what it would cost to get it done by someone else than spend any more time on it.

So, what I believe I need is someone to build a VBA macro thing to execute the import, and to explain to me what I need to do to make it work in a spreadsheet. If there's some other way to do it feel free to correct me.

I don't think it would actually take that long to build for someone who knows what they are doing, but unfortunately that someone isn't currently me.

If you think you can make it happen shoot me a PM or post with a cost quote and I'll get back to you. I'll leave off making a decision for awhile and let the free market do its thing Smiley

Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1526994408
Hero Member
*
Offline Offline

Posts: 1526994408

View Profile Personal Message (Offline)

Ignore
1526994408
Reply with quote  #2

1526994408
Report to moderator
1526994408
Hero Member
*
Offline Offline

Posts: 1526994408

View Profile Personal Message (Offline)

Ignore
1526994408
Reply with quote  #2

1526994408
Report to moderator
Eveofwar
Sr. Member
****
Offline Offline

Activity: 406
Merit: 250


View Profile
August 19, 2013, 05:31:39 PM
 #2

I want to be able to import this: http://api.bitcoincharts.com/v1/weighted_prices.json into Excel.

This: http://ramblings.mcpher.com/Home/excelquirks/json apparently explains how to do so.

However, I find I'm missing some basic steps/knowledge. I really have no idea how to make it work and would rather see what it would cost to get it done by someone else than spend any more time on it.

So, what I believe I need is someone to build a VBA macro thing to execute the import, and to explain to me what I need to do to make it work in a spreadsheet. If there's some other way to do it feel free to correct me.

I don't think it would actually take that long to build for someone who knows what they are doing, but unfortunately that someone isn't currently me.

If you think you can make it happen shoot me a PM or post with a cost quote and I'll get back to you. I'll leave off making a decision for awhile and let the free market do its thing Smiley

PM sent.
ColdHardMetal
Hero Member
*****
Offline Offline

Activity: 700
Merit: 500



View Profile
August 20, 2013, 02:51:33 AM
 #3

Looks like this is done. Thanks to all who replied.

Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!