z

[EskimoBob]

Not sure if people have a better solution, but here's a function (formatting shamelessly ripped from znort987) to fetch the time weighted prices from bitcoincharts.com (e.g. the 24h USDBTC average). I think these are better to use than MTGox quotes if you're doing P&L calcs.

Why do you want to use something like time weighted prices or averages of 24H etc for P&L calculations? All you get is a distorted view of what is really going on "as of now (or what ever date/time you need)".

[1715619072]

1715619072

[1715619072]

1715619072

[Nefario]

Remember the API has a limit of 10 requests per min.

I'm in the process of having the api and charts re-written for better usability and performance.

[sunnankar]

I've started a small git repo with useful Google Docs JavaScript macros to automatically interact

Thought those that want to import a wallet balance may find this helpful:

Code:

=ImportData(CONCAT("http://blockchain.info/q/addressbalance/",C27))/100000000