how to transfer Lots/cost basis from wallet to wallet

2021-04-10 Thread david e
I am adding my crypto tx history manually to my bean-file and am wondering 
about how to send from one wallet to another by respecting the cost basis.

example:

2020-01-01 * "send eth from wallet a to b"
Assets:Crypto:WalletA   -1.00 ETH {} ;bean fetches cost basis
Assets:Crypto:WalletB1.00 ETH {} ;how to match them here?

when I run bean-report myfile.bean print, I can then see that 1.00 ETH from 
WalletA contains several Lots that now have to be transferred to Wallet B 
(as this isn't a taxable event I want to keep the cost basis).

is there a way to hand the exact amount over either as an average or with 
the Lots as is?

thanks lot

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/274e7cac-cd45-45e3--2f77732f2405n%40googlegroups.com.


Re: transaction costs:

2021-04-10 Thread david e
wouldn't it be correct to add the transaction costs in its own account into 
the transaction, and thereby beancount is able to list the fees separately?

compared to my example from above I would have to add one line:

2018-01-01 * "Send 1.5 ETH & 0.05 ETH gas"
Assets:Crypto:ETH -1.5 ETH {}  ;; list the ETH amount without tx cost
Expenses:Crypto 100 USD;; matching the 1.5 eth
Assets:Crypto:ETH -0.05 ETH {} ;; tx cost listed separately
Expenses:Crypto:Fees  1 USD;; cost matching the 0.05 eth
Income:Crypto:PnL

this way I would be able to query for all entries including fees and 
therefore this solution works instead of dividing the tx into two entries? 


bl...@furius.ca schrieb am Mittwoch, 7. April 2021 um 00:16:41 UTC+2:

> There's no facility to do this.
> You can write a script to handle the separation by processing the stream 
> of transactions yourself.
>
>
> On Tue, Apr 6, 2021 at 3:16 PM david e  wrote:
>
>> I am wondering about how to book transaction costs correctly. as I am 
>> doing ethereum tx, I have to track cost basis of the fees. compared to 
>> paying fees to a broker, this is a bit more work.  
>>
>> my entry would look like this: 
>>
>> 2018-01-01 * "Send 1.5 ETH & 0.05 ETH gas"
>> Assets:Crypto:ETH -1.55 ETH {}
>> Expenses:Crypto 100 USD
>> Expenses:Crypto:Fees 1 USD
>> Income:Crypto:PnL 
>>
>> but in this case, the PnL is the total of both ETH entries (Assets and 
>> Fees). to have the entries separated, it could look like this, split into 
>> two entries:
>>
>> 2018-01-01 * "Send 1.5 ETH example"
>> Assets:Crypto:ETH -1.5 ETH {}
>> Expenses:Crypto 100 USD
>> Income:Crypto:PnL 
>>
>> 2018-01-01 * "Send 0.05 ETH for gas example"
>> Assets:Crypto:ETH -0.05 ETH {}
>> Expenses:Crypto:Fees 1 USD
>> Income:Crypto:PnL 
>>
>> my question: is it possible to calculate / report the PnL of the fees 
>> separately even though I list it in one entry as shown above? or do I have 
>> to split it for correct calculation?
>>
>> my assumption is that for tax reporting I have to be able to list PnL for 
>> each position and therefore it would be a problem to mix it with the fees. 
>>
>> thanks
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Beancount" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to beancount+...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/beancount/929614fd-dbff-4a6f-a43e-07dfd3ab7879n%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/2d7daa6e-32a2-4a33-92b2-af1b48dbf29cn%40googlegroups.com.


Re: transaction costs:

2021-04-10 Thread Martin Blais
Beancount won't be able to work out the booking automatically this way, too
many unknown numbers to fill in.


On Sat, Apr 10, 2021 at 10:08 AM david e  wrote:

> wouldn't it be correct to add the transaction costs in its own account
> into the transaction, and thereby beancount is able to list the fees
> separately?
>
> compared to my example from above I would have to add one line:
>
> 2018-01-01 * "Send 1.5 ETH & 0.05 ETH gas"
> Assets:Crypto:ETH -1.5 ETH {}  ;; list the ETH amount without tx cost
> Expenses:Crypto 100 USD;; matching the 1.5 eth
> Assets:Crypto:ETH -0.05 ETH {} ;; tx cost listed separately
> Expenses:Crypto:Fees  1 USD;; cost matching the 0.05 eth
> Income:Crypto:PnL
>
> this way I would be able to query for all entries including fees and
> therefore this solution works instead of dividing the tx into two entries?
>
>
> bl...@furius.ca schrieb am Mittwoch, 7. April 2021 um 00:16:41 UTC+2:
>
>> There's no facility to do this.
>> You can write a script to handle the separation by processing the stream
>> of transactions yourself.
>>
>>
>> On Tue, Apr 6, 2021 at 3:16 PM david e  wrote:
>>
>>> I am wondering about how to book transaction costs correctly. as I am
>>> doing ethereum tx, I have to track cost basis of the fees. compared to
>>> paying fees to a broker, this is a bit more work.
>>>
>>> my entry would look like this:
>>>
>>> 2018-01-01 * "Send 1.5 ETH & 0.05 ETH gas"
>>> Assets:Crypto:ETH -1.55 ETH {}
>>> Expenses:Crypto 100 USD
>>> Expenses:Crypto:Fees 1 USD
>>> Income:Crypto:PnL
>>>
>>> but in this case, the PnL is the total of both ETH entries (Assets and
>>> Fees). to have the entries separated, it could look like this, split into
>>> two entries:
>>>
>>> 2018-01-01 * "Send 1.5 ETH example"
>>> Assets:Crypto:ETH -1.5 ETH {}
>>> Expenses:Crypto 100 USD
>>> Income:Crypto:PnL
>>>
>>> 2018-01-01 * "Send 0.05 ETH for gas example"
>>> Assets:Crypto:ETH -0.05 ETH {}
>>> Expenses:Crypto:Fees 1 USD
>>> Income:Crypto:PnL
>>>
>>> my question: is it possible to calculate / report the PnL of the fees
>>> separately even though I list it in one entry as shown above? or do I have
>>> to split it for correct calculation?
>>>
>>> my assumption is that for tax reporting I have to be able to list PnL
>>> for each position and therefore it would be a problem to mix it with the
>>> fees.
>>>
>>> thanks
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Beancount" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to beancount+...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/beancount/929614fd-dbff-4a6f-a43e-07dfd3ab7879n%40googlegroups.com
>>> 
>>> .
>>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Beancount" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to beancount+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/2d7daa6e-32a2-4a33-92b2-af1b48dbf29cn%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAK21%2BhOFsaOnZmh6d%2BkB9bO%2Bb2nn4fV%3Df2w6WaxqO9C1CsicUA%40mail.gmail.com.


Re: transaction costs:

2021-04-10 Thread david e
but it doesn't return an error and compared to my manual calculation the 
amount for PnL seems correct.

I guess you mean beancount isn't able to divide the PnL for each accounts, 
only the sum to match the entries?

bl...@furius.ca schrieb am Samstag, 10. April 2021 um 16:13:47 UTC+2:

> Beancount won't be able to work out the booking automatically this way, 
> too many unknown numbers to fill in.
>
>
> On Sat, Apr 10, 2021 at 10:08 AM david e  wrote:
>
>> wouldn't it be correct to add the transaction costs in its own account 
>> into the transaction, and thereby beancount is able to list the fees 
>> separately?
>>
>> compared to my example from above I would have to add one line:
>>
>> 2018-01-01 * "Send 1.5 ETH & 0.05 ETH gas"
>> Assets:Crypto:ETH -1.5 ETH {}  ;; list the ETH amount without tx cost
>> Expenses:Crypto 100 USD;; matching the 1.5 eth
>> Assets:Crypto:ETH -0.05 ETH {} ;; tx cost listed separately
>> Expenses:Crypto:Fees  1 USD;; cost matching the 0.05 eth
>> Income:Crypto:PnL
>>
>> this way I would be able to query for all entries including fees and 
>> therefore this solution works instead of dividing the tx into two entries? 
>>
>>
>> bl...@furius.ca schrieb am Mittwoch, 7. April 2021 um 00:16:41 UTC+2:
>>
>>> There's no facility to do this.
>>> You can write a script to handle the separation by processing the stream 
>>> of transactions yourself.
>>>
>>>
>>> On Tue, Apr 6, 2021 at 3:16 PM david e  wrote:
>>>
 I am wondering about how to book transaction costs correctly. as I am 
 doing ethereum tx, I have to track cost basis of the fees. compared to 
 paying fees to a broker, this is a bit more work.  

 my entry would look like this: 

 2018-01-01 * "Send 1.5 ETH & 0.05 ETH gas"
 Assets:Crypto:ETH -1.55 ETH {}
 Expenses:Crypto 100 USD
 Expenses:Crypto:Fees 1 USD
 Income:Crypto:PnL 

 but in this case, the PnL is the total of both ETH entries (Assets and 
 Fees). to have the entries separated, it could look like this, split into 
 two entries:

 2018-01-01 * "Send 1.5 ETH example"
 Assets:Crypto:ETH -1.5 ETH {}
 Expenses:Crypto 100 USD
 Income:Crypto:PnL 

 2018-01-01 * "Send 0.05 ETH for gas example"
 Assets:Crypto:ETH -0.05 ETH {}
 Expenses:Crypto:Fees 1 USD
 Income:Crypto:PnL 

 my question: is it possible to calculate / report the PnL of the fees 
 separately even though I list it in one entry as shown above? or do I have 
 to split it for correct calculation?

 my assumption is that for tax reporting I have to be able to list PnL 
 for each position and therefore it would be a problem to mix it with the 
 fees. 

 thanks

 -- 
 You received this message because you are subscribed to the Google 
 Groups "Beancount" group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to beancount+...@googlegroups.com.
 To view this discussion on the web visit 
 https://groups.google.com/d/msgid/beancount/929614fd-dbff-4a6f-a43e-07dfd3ab7879n%40googlegroups.com
  
 
 .

>>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Beancount" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to beancount+...@googlegroups.com.
>>
> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/beancount/2d7daa6e-32a2-4a33-92b2-af1b48dbf29cn%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/84b810d5-8db6-4f8a-9022-9a78fe446fd4n%40googlegroups.com.


Re: how to transfer Lots/cost basis from wallet to wallet

2021-04-10 Thread Martin Blais
It doesn't do that for you.
It can book against the existing lots (e.g. with FIFO) but on the opening
side (WalletB) it won't know to fill in the corresponding average cost
basis.
If you do this a lot, you'll have to automate with a script.

I think eventually some features need to be built for users of DA but I
don't know what they all should be yet, and I don't use the stuff much
myself, I have some, but I don't spend any. Crypto's a bit of a headache if
you use them as dual purpose to spend or transfer and as speculation. If
tracking really matters to you, I think you'll make your life easier if you
separate those two worlds.





On Sat, Apr 10, 2021 at 10:00 AM david e  wrote:

> I am adding my crypto tx history manually to my bean-file and am wondering
> about how to send from one wallet to another by respecting the cost basis.
>
> example:
>
> 2020-01-01 * "send eth from wallet a to b"
> Assets:Crypto:WalletA   -1.00 ETH {} ;bean fetches cost basis
> Assets:Crypto:WalletB1.00 ETH {} ;how to match them here?
>
> when I run bean-report myfile.bean print, I can then see that 1.00 ETH
> from WalletA contains several Lots that now have to be transferred to
> Wallet B (as this isn't a taxable event I want to keep the cost basis).
>
> is there a way to hand the exact amount over either as an average or with
> the Lots as is?
>
> thanks lot
>
> --
> You received this message because you are subscribed to the Google Groups
> "Beancount" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to beancount+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/274e7cac-cd45-45e3--2f77732f2405n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAK21%2BhMKWi4aiko6sNNzFQASLu7WUsYPdZnPMt%3D0D3xaVkMqKw%40mail.gmail.com.


Re: how to transfer Lots/cost basis from wallet to wallet

2021-04-10 Thread david e
I see, thanks!

bl...@furius.ca schrieb am Samstag, 10. April 2021 um 16:19:50 UTC+2:

> It doesn't do that for you.
> It can book against the existing lots (e.g. with FIFO) but on the opening 
> side (WalletB) it won't know to fill in the corresponding average cost 
> basis.
> If you do this a lot, you'll have to automate with a script.
>
> I think eventually some features need to be built for users of DA but I 
> don't know what they all should be yet, and I don't use the stuff much 
> myself, I have some, but I don't spend any. Crypto's a bit of a headache if 
> you use them as dual purpose to spend or transfer and as speculation. If 
> tracking really matters to you, I think you'll make your life easier if you 
> separate those two worlds.
>
>
>
>
>
> On Sat, Apr 10, 2021 at 10:00 AM david e  wrote:
>
>> I am adding my crypto tx history manually to my bean-file and am 
>> wondering about how to send from one wallet to another by respecting the 
>> cost basis.
>>
>> example:
>>
>> 2020-01-01 * "send eth from wallet a to b"
>> Assets:Crypto:WalletA   -1.00 ETH {} ;bean fetches cost basis
>> Assets:Crypto:WalletB1.00 ETH {} ;how to match them here?
>>
>> when I run bean-report myfile.bean print, I can then see that 1.00 ETH 
>> from WalletA contains several Lots that now have to be transferred to 
>> Wallet B (as this isn't a taxable event I want to keep the cost basis).
>>
>> is there a way to hand the exact amount over either as an average or with 
>> the Lots as is?
>>
>> thanks lot
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Beancount" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to beancount+...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/beancount/274e7cac-cd45-45e3--2f77732f2405n%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/19b2c568-214e-498b-8578-a026b12c4496n%40googlegroups.com.


Re: transaction costs:

2021-04-10 Thread Martin Blais
No I though the two separate {} could not be booked. I don't remember.
I don't remember what I did, look at file booking_full.py for details.



On Sat, Apr 10, 2021 at 10:19 AM david e  wrote:

> but it doesn't return an error and compared to my manual calculation the
> amount for PnL seems correct.
>
> I guess you mean beancount isn't able to divide the PnL for each accounts,
> only the sum to match the entries?
>
> bl...@furius.ca schrieb am Samstag, 10. April 2021 um 16:13:47 UTC+2:
>
>> Beancount won't be able to work out the booking automatically this way,
>> too many unknown numbers to fill in.
>>
>>
>> On Sat, Apr 10, 2021 at 10:08 AM david e  wrote:
>>
>>> wouldn't it be correct to add the transaction costs in its own account
>>> into the transaction, and thereby beancount is able to list the fees
>>> separately?
>>>
>>> compared to my example from above I would have to add one line:
>>>
>>> 2018-01-01 * "Send 1.5 ETH & 0.05 ETH gas"
>>> Assets:Crypto:ETH -1.5 ETH {}  ;; list the ETH amount without tx cost
>>> Expenses:Crypto 100 USD;; matching the 1.5 eth
>>> Assets:Crypto:ETH -0.05 ETH {} ;; tx cost listed separately
>>> Expenses:Crypto:Fees  1 USD;; cost matching the 0.05 eth
>>> Income:Crypto:PnL
>>>
>>> this way I would be able to query for all entries including fees and
>>> therefore this solution works instead of dividing the tx into two entries?
>>>
>>>
>>> bl...@furius.ca schrieb am Mittwoch, 7. April 2021 um 00:16:41 UTC+2:
>>>
 There's no facility to do this.
 You can write a script to handle the separation by processing the
 stream of transactions yourself.


 On Tue, Apr 6, 2021 at 3:16 PM david e  wrote:

> I am wondering about how to book transaction costs correctly. as I am
> doing ethereum tx, I have to track cost basis of the fees. compared to
> paying fees to a broker, this is a bit more work.
>
> my entry would look like this:
>
> 2018-01-01 * "Send 1.5 ETH & 0.05 ETH gas"
> Assets:Crypto:ETH -1.55 ETH {}
> Expenses:Crypto 100 USD
> Expenses:Crypto:Fees 1 USD
> Income:Crypto:PnL
>
> but in this case, the PnL is the total of both ETH entries (Assets and
> Fees). to have the entries separated, it could look like this, split into
> two entries:
>
> 2018-01-01 * "Send 1.5 ETH example"
> Assets:Crypto:ETH -1.5 ETH {}
> Expenses:Crypto 100 USD
> Income:Crypto:PnL
>
> 2018-01-01 * "Send 0.05 ETH for gas example"
> Assets:Crypto:ETH -0.05 ETH {}
> Expenses:Crypto:Fees 1 USD
> Income:Crypto:PnL
>
> my question: is it possible to calculate / report the PnL of the fees
> separately even though I list it in one entry as shown above? or do I have
> to split it for correct calculation?
>
> my assumption is that for tax reporting I have to be able to list PnL
> for each position and therefore it would be a problem to mix it with the
> fees.
>
> thanks
>
> --
> You received this message because you are subscribed to the Google
> Groups "Beancount" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to beancount+...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/929614fd-dbff-4a6f-a43e-07dfd3ab7879n%40googlegroups.com
> 
> .
>
 --
>>> You received this message because you are subscribed to the Google
>>> Groups "Beancount" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to beancount+...@googlegroups.com.
>>>
>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/beancount/2d7daa6e-32a2-4a33-92b2-af1b48dbf29cn%40googlegroups.com
>>> 
>>> .
>>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Beancount" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to beancount+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/84b810d5-8db6-4f8a-9022-9a78fe446fd4n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAK21%2BhPeR7NO34_amhK_mGmfQN9kcKAKuMM_wt87YFaqraRMwQ%40mail

Re: how to transfer Lots/cost basis from wallet to wallet

2021-04-10 Thread Ben Blount
There were several recent threads on this subject that go into more
details. I'm on mobile or I'd give you a link.

On Sat, Apr 10, 2021, 07:24 david e  wrote:

> I see, thanks!
>
> bl...@furius.ca schrieb am Samstag, 10. April 2021 um 16:19:50 UTC+2:
>
>> It doesn't do that for you.
>> It can book against the existing lots (e.g. with FIFO) but on the opening
>> side (WalletB) it won't know to fill in the corresponding average cost
>> basis.
>> If you do this a lot, you'll have to automate with a script.
>>
>> I think eventually some features need to be built for users of DA but I
>> don't know what they all should be yet, and I don't use the stuff much
>> myself, I have some, but I don't spend any. Crypto's a bit of a headache if
>> you use them as dual purpose to spend or transfer and as speculation. If
>> tracking really matters to you, I think you'll make your life easier if you
>> separate those two worlds.
>>
>>
>>
>>
>>
>> On Sat, Apr 10, 2021 at 10:00 AM david e  wrote:
>>
>>> I am adding my crypto tx history manually to my bean-file and am
>>> wondering about how to send from one wallet to another by respecting the
>>> cost basis.
>>>
>>> example:
>>>
>>> 2020-01-01 * "send eth from wallet a to b"
>>> Assets:Crypto:WalletA   -1.00 ETH {} ;bean fetches cost basis
>>> Assets:Crypto:WalletB1.00 ETH {} ;how to match them here?
>>>
>>> when I run bean-report myfile.bean print, I can then see that 1.00 ETH
>>> from WalletA contains several Lots that now have to be transferred to
>>> Wallet B (as this isn't a taxable event I want to keep the cost basis).
>>>
>>> is there a way to hand the exact amount over either as an average or
>>> with the Lots as is?
>>>
>>> thanks lot
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Beancount" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to beancount+...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/beancount/274e7cac-cd45-45e3--2f77732f2405n%40googlegroups.com
>>> 
>>> .
>>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Beancount" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to beancount+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/19b2c568-214e-498b-8578-a026b12c4496n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CACGEkZvXftH%3DNZridk0A%2BVEVwjWfqf2VhYoAuktfpkemfZFSVg%40mail.gmail.com.


Re: Currency exchange rates sources

2021-04-10 Thread Stefano Zacchiroli
On Sat, Nov 07, 2020 at 12:29:37AM +0100, Daniele Nicolodi wrote:
> For example, OANDA https://www1.oanda.com and fxtop https://fxtop.com/
> have web data sources that could be easily scraped for data.

At the time this thread started, I was using
https://exchangeratesapi.io/ which Martin (M.) also mentioned in the
thread. Since then, they have changed their terms of use: it is no
longer possible to use the API at all without an API key, and even with
an API key it is not possible to set the base currency if you are on the
free API usage tier.

I have checked a couple of other similar services, and it seems that
this is now a common restriction: no base currency selection within the
free API usage tiers.

I'm hence about to scrape one of the two sources mentioned by Daniele
above. Doing so makes me sad, but it's better than nothing.

If in the meantime others have found viable alternatives, please shout!

Cheers
-- 
Stefano Zacchiroli . z...@upsilon.cc . upsilon.cc/zack . . o . . . o . o
Computer Science Professor . CTO Software Heritage . . . . . o . . . o o
Former Debian Project Leader & OSI Board Director  . . . o o o . . . o .
« the first rule of tautology club is the first rule of tautology club »

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/20210410151344.r7lgggioinkow7by%40upsilon.cc.


Re: Currency exchange rates sources

2021-04-10 Thread Uwe Ziegenhagen
>
> If in the meantime others have found viable alternatives, please shout!
>
>
How about the fx rates from European Central Bank?

https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html

XML interface, historic rates, etc. are available.

Uwe

-- 
Dr. Uwe Ziegenhagen
0179-7476050


-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAML7JCj-KHMJXpiveDFgHxBXqkaAWv4hFx1Z%3DBns1h6mwWE8gA%40mail.gmail.com.


Beancount - Symbology - Invitation to comment

2021-04-10 Thread Martin Blais (via Google Docs)

I've shared an item with you:

Beancount - Symbology
https://docs.google.com/document/d/1_52VhapAuR-ej4yB8rFovA8MyMmF8IOcqO44apsdtKU/edit?usp=sharing&ts=6071c917

It's not an attachment -- it's stored online. To open this item, just click  
the link above.


A quick note on the symbol conventions I use. Suggestions welcome.

--
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/ad4d9605bfa03a8f%40google.com.


Re: Currency exchange rates sources

2021-04-10 Thread 'Patrick Ruckstuhl' via Beancount

Hi,


you can use https://ratesapi.io/ same api as exchangeratesapi before, 
simply switching the host is enough.


Besides that, https://www.alphavantage.co/ free tier works also pretty 
well. Price fetchers available at https://github.com/tarioch/beancounttools




Regards,

Patrick



On 10.04.2021 17:25, Uwe Ziegenhagen wrote:



If in the meantime others have found viable alternatives, please
shout!


How about the fx rates from European Central Bank?

https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html 



XML interface, historic rates, etc. are available.

Uwe

--
Dr. Uwe Ziegenhagen
0179-7476050
>
--
You received this message because you are subscribed to the Google 
Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to beancount+unsubscr...@googlegroups.com 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/CAML7JCj-KHMJXpiveDFgHxBXqkaAWv4hFx1Z%3DBns1h6mwWE8gA%40mail.gmail.com 
.


--
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/a7e6649f-3267-5a2c-526c-4a6923da191e%40ch.tario.org.


Re: Currency exchange rates sources

2021-04-10 Thread Stefano Zacchiroli
On Sat, Apr 10, 2021 at 05:52:41PM +0200, 'Patrick Ruckstuhl' via Beancount 
wrote:
> you can use https://ratesapi.io/ same api as exchangeratesapi before, simply
> switching the host is enough.
> 
> Besides that, https://www.alphavantage.co/ free tier works also pretty well.
> Price fetchers available at https://github.com/tarioch/beancounttools

This is awesome, thank you !

-- 
Stefano Zacchiroli . z...@upsilon.cc . upsilon.cc/zack . . o . . . o . o
Computer Science Professor . CTO Software Heritage . . . . . o . . . o o
Former Debian Project Leader & OSI Board Director  . . . o o o . . . o .
« the first rule of tautology club is the first rule of tautology club »

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/20210410174311.gwwq4g3yhppjauwh%40upsilon.cc.


Re: Currency exchange rates sources

2021-04-10 Thread Daniele Nicolodi
On 10/04/2021 17:25, Uwe Ziegenhagen wrote:
> 
> 
> If in the meantime others have found viable alternatives, please shout!
> 
> 
> How about the fx rates from European Central Bank?
> 
> https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html
> 
> 
> XML interface, historic rates, etc. are available.

The problem with this data is that these are reference exchange rates
and not market exchange rate, thus, depending on what is your goal,
these may not be what you need.

Cheers,
Dan

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/6aa56001-e4fa-b59d-3b0a-eebcc1618794%40grinta.net.