Nostr Web Client

We'll look for additional ways to optimize.

You guys are the best!

Replying to

Great, we made an update with historical price data saved in the file, so google doesn't have to pull as much information every time. If you go to the same link you can try out the new version.

Yes that works way better! The macro still errors out with 500 transactions though

Replying to

Thanks for the feedback, we'll check it out.

I was able to get it working by batching my hourly DCA to daily transactions, reducing it from 500 to 90 transactions. It worked great then! However, the BTC price tool would timeout if there were more than 10-20 transactions no matter what I did. Thank you so much for releasing such a great tool!

Replying to Horse Staple Battery

I keep getting " exceeded maximum execution time" when running the HIFO script on the Google sheets doc. Any ideas? I have about 500 transactions because of 2 weeks where I did hourly DCA

nostr:nprofile1qqsx3lh8hd7z4sglwgr2s9c7dw23f26a35c3gy7artuxjpmce6hqa5qpzemhxue69uhhwmm59ehx7um5wgh8qctjw3uj7k9w5m8

Replying to

https://satoshipacioli.com/new-google-sheet-excel-template/

February means tax season is officially in full swing!

We often get asked about the best tools for tracking bitcoin taxes and most of what is available focuses on serving crypto broadly and is not customizable. So we put together a simple spreadsheet to share with the community.

There are two versions, one in google sheets and the other in excel.

This is our first version and we would love to make continued improvements based on user feedback.

Currently it tracks gains/losses based on FIFO/LIFO/HIFO and your current cost basis of coins held.