Perfect, thanks. I tried it out, and the data imported beautifully, however, the calculations on the side quickly returned #value cells. I think there is a bug with the calcvalue() method since the first non-dependent cell to be #value is a simple calcvalue(str,1) call with str being
"BTC sold: [tid:1325141427287997] 5.75000000Â BTC at $4.26000"
without quotes.
-Mike
All you need to do is drag the formulas down and refresh them. They won't automatically do it. Also keep in mind that the running total columns for USD and BTC need the first value SET at the bottom.
They need to start adding to something so the formula copied down won't calculate without that first row at the VERY bottom being set to a value. So in my case my first deposit at the bottom was $30 so I could just type in 30 in the USD running total column at the bottom.
Edit: Those calculations are definitely not 100% bug free because I wanted to release this sooner than later so I put those in to give more of a starting place for whatever someone wanted to do. I am working on making them 100% solid though and will update it probably tomorrow. My first goal was assuring that the import was 100% airtight for the known transactions.