Quote:
Originally Posted by latepaul
I think I added it because someone else talked about it on here! I do like to keep an eye on how much I am spending. Actually I don't do that as much as I used to. I used to feel guilty if I was buying new books (especially if they might later go on sale) when I had so many unread ones.
I actually run SQL directly against the calibre database to look at things like total price. I work in databases so it's pretty natural for me.
So I have a script called "mr_status", which if I run it now shows me this:
Code:
MR Report for Year beginning: 2018-01-01
title num_books
---------- ----------
Read Books 8
TBR 560
title num_books total_cost
------------ ---------- ----------
Money Spent 4 £ 14.85
Free Books 2 £ 0.00
Cost of TBR 431 £ 922.40
Cost of Read 7 £ 16.65
NB: counts with prices may be out due to books with no price
So I've bought 4 books this year, spending £14.85. But I've read 8 which cost £16.65 - so that's good because I'm reading more cost-wise than I'm spending. So I've reduced that "Cost of TBR" figure a little bit.
I'm not too bothered by that by the way. It has built up over years. My spending on books is still less than on things like coffee.
You can also see that I read 8 books but only 7 appear in the price section. That's because one (Frankenstein) was a PD title that I got for free.
Actually I've read 9 books this year, but the other one was a re-read and my "read date" column only records the first read. I'm OK with that, particularly when looking at the price. Counting the full price as part of the read when I've read it before wouldn't be quite right. |
It sounds like you have a very useful tool in finding out all that price information. I would be very keen to try that but I don't think I can as don't have access to SQL database. You wouldn't by any chance have experience in python and be able to make a
plugin would you?
Anyway it looks like I will just have to use the export catalog function and then use excel to sort the data I need for price.
Inukami