You are viewing a plain text version of this content. The canonical link for it is here.
Posted to l10n@openoffice.apache.org by Czesław Wolański <cz...@gmail.com> on 2022/08/17 07:03:03 UTC
"()" in the description of the TBILLEQ function
Hi,
Help for Calc,
Financial Functions Part Two, the TBILLEQ function:
TBILLEQ
"Calculates the annual return on a treasury bill ().
A treasury bill is purchased on the settlement date and sold at the full
par value on the maturity date,
that must fall within the same year. A discount is deducted from the
purchase price."'
What is the purpose of "()" in the first sentence of the above description?
Regards,
Czesław
LINKS:
[1]
Pootle, Help,
location: 04060119.xhp#par_id3154403.59.help.text
<ahelp hid="HID_AAI_FUNC_TBILLEQ">Calculates the annual return on a
treasury bill ().</ahelp>
[2]
AOO Wiki, documentation/How Tos/Calc:
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_TBILLEQ_function
TBILLEQ
"Returns the bond-equivalent-yield (BEY) for a US Treasury bill.
[...]
Issues:
This function may assist with US Treasury bills if used carefully. The
underlying formula may not apply to Treasury bills issued by other
governments."
[3]
Calc Guide (OpenOffice.org 3.3),
Appendix B Description of Functions,p. 391
TBILLEQ - "Calculates the annual return on a treasury bill."
Re: "()" in the description of the TBILLEQ function
Posted by Matthias Seidel <ma...@hamburg.de>.
Hi Taavi,
Am 18.08.22 um 22:39 schrieb Taavi Kaevats:
> Hi all,
>
> I am not sure, what is the purpose of empty brackets there, however my
> cents are the following:
>
> Formula
>
> =TBILLEQ(settlement, maturity, discount)
>
> The TBILLEQ function uses the following required arguments:
>
> 1. Settlement – This is the settlement date of the T-bill. It is the
> date after the issue date when the T-bill is traded to the buyer.
> 2. Maturity – The date when the T-bill will expire. It must be greater
> than and within one year of the settlement date. This is so, as the life of
> T-bills is less than one year.
> 3. Discount – The T-bill discount rate. We can take from the risk-free
> investment rate if unavailable
Thanks for your input!
I have removed the "()" with my latest commit.
Regards,
Matthias
> With best wishes from Estonia,
> Taavi
>
> N, 18. august 2022 16:23 Matthias Seidel <ma...@hamburg.de>
> kirjutas:
>
>> Hi Czesław,
>>
>> It seems we have the same opinion on "()" ;-)
>>
>> Others don't seem to be interested, so I will remove it with my next
>> commit.
>>
>> Regards,
>>
>> Matthias
>>
>> Am 17.08.22 um 17:52 schrieb Czesław Wolański:
>>> Hi,
>>>
>>> You meant
>>>
>>> "His Judgment Cometh
>>> and that Right Soon...."?
>>>
>>> (The Shawshank Redemption, 1994)
>>>
>>> Regards,
>>> Czesław
>>>
>>> Il giorno mer 17 ago 2022 alle ore 17:41 Matthias Seidel <
>>> matthias.seidel@hamburg.de> ha scritto:
>>>
>>>> I saw that coming! ;-)
>>>>
>>>> Am 17.08.22 um 17:38 schrieb Czesław Wolański:
>>>>> On 2022/08/17 14:54:36 Matthias Seidel wrote:
>>>>>> Indeed, that () does not make sense (to me).
>>>>>>
>>>>> How about this:
>>>>> "Calculates the annual return on a treasury bill (to me)"? ;‑)
>>>>>
>>>>> Regards,
>>>>> Czesław
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: l10n-unsubscribe@openoffice.apache.org
>>>>> For additional commands, e-mail: l10n-help@openoffice.apache.org
>>>>>
>>
Re: "()" in the description of the TBILLEQ function
Posted by Taavi Kaevats <ta...@gmail.com>.
Hi all,
I am not sure, what is the purpose of empty brackets there, however my
cents are the following:
Formula
=TBILLEQ(settlement, maturity, discount)
The TBILLEQ function uses the following required arguments:
1. Settlement – This is the settlement date of the T-bill. It is the
date after the issue date when the T-bill is traded to the buyer.
2. Maturity – The date when the T-bill will expire. It must be greater
than and within one year of the settlement date. This is so, as the life of
T-bills is less than one year.
3. Discount – The T-bill discount rate. We can take from the risk-free
investment rate if unavailable
With best wishes from Estonia,
Taavi
N, 18. august 2022 16:23 Matthias Seidel <ma...@hamburg.de>
kirjutas:
> Hi Czesław,
>
> It seems we have the same opinion on "()" ;-)
>
> Others don't seem to be interested, so I will remove it with my next
> commit.
>
> Regards,
>
> Matthias
>
> Am 17.08.22 um 17:52 schrieb Czesław Wolański:
> > Hi,
> >
> > You meant
> >
> > "His Judgment Cometh
> > and that Right Soon...."?
> >
> > (The Shawshank Redemption, 1994)
> >
> > Regards,
> > Czesław
> >
> > Il giorno mer 17 ago 2022 alle ore 17:41 Matthias Seidel <
> > matthias.seidel@hamburg.de> ha scritto:
> >
> >> I saw that coming! ;-)
> >>
> >> Am 17.08.22 um 17:38 schrieb Czesław Wolański:
> >>> On 2022/08/17 14:54:36 Matthias Seidel wrote:
> >>>> Indeed, that () does not make sense (to me).
> >>>>
> >>> How about this:
> >>> "Calculates the annual return on a treasury bill (to me)"? ;‑)
> >>>
> >>> Regards,
> >>> Czesław
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: l10n-unsubscribe@openoffice.apache.org
> >>> For additional commands, e-mail: l10n-help@openoffice.apache.org
> >>>
> >>
>
>
Re: "()" in the description of the TBILLEQ function
Posted by Matthias Seidel <ma...@hamburg.de>.
Hi Czesław,
It seems we have the same opinion on "()" ;-)
Others don't seem to be interested, so I will remove it with my next commit.
Regards,
Matthias
Am 17.08.22 um 17:52 schrieb Czesław Wolański:
> Hi,
>
> You meant
>
> "His Judgment Cometh
> and that Right Soon...."?
>
> (The Shawshank Redemption, 1994)
>
> Regards,
> Czesław
>
> Il giorno mer 17 ago 2022 alle ore 17:41 Matthias Seidel <
> matthias.seidel@hamburg.de> ha scritto:
>
>> I saw that coming! ;-)
>>
>> Am 17.08.22 um 17:38 schrieb Czesław Wolański:
>>> On 2022/08/17 14:54:36 Matthias Seidel wrote:
>>>> Indeed, that () does not make sense (to me).
>>>>
>>> How about this:
>>> "Calculates the annual return on a treasury bill (to me)"? ;‑)
>>>
>>> Regards,
>>> Czesław
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: l10n-unsubscribe@openoffice.apache.org
>>> For additional commands, e-mail: l10n-help@openoffice.apache.org
>>>
>>
Re: "()" in the description of the TBILLEQ function
Posted by Czesław Wolański <cz...@gmail.com>.
Hi,
You meant
"His Judgment Cometh
and that Right Soon...."?
(The Shawshank Redemption, 1994)
Regards,
Czesław
Il giorno mer 17 ago 2022 alle ore 17:41 Matthias Seidel <
matthias.seidel@hamburg.de> ha scritto:
> I saw that coming! ;-)
>
> Am 17.08.22 um 17:38 schrieb Czesław Wolański:
> >
> > On 2022/08/17 14:54:36 Matthias Seidel wrote:
> >> Indeed, that () does not make sense (to me).
> >>
> > How about this:
> > "Calculates the annual return on a treasury bill (to me)"? ;‑)
> >
> > Regards,
> > Czesław
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: l10n-unsubscribe@openoffice.apache.org
> > For additional commands, e-mail: l10n-help@openoffice.apache.org
> >
>
>
Re: "()" in the description of the TBILLEQ function
Posted by Matthias Seidel <ma...@hamburg.de>.
I saw that coming! ;-)
Am 17.08.22 um 17:38 schrieb Czesław Wolański:
>
> On 2022/08/17 14:54:36 Matthias Seidel wrote:
>> Indeed, that () does not make sense (to me).
>>
> How about this:
> "Calculates the annual return on a treasury bill (to me)"? ;‑)
>
> Regards,
> Czesław
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: l10n-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: l10n-help@openoffice.apache.org
>
Re: "()" in the description of the TBILLEQ function
Posted by Czesław Wolański <cw...@apache.org>.
On 2022/08/17 14:54:36 Matthias Seidel wrote:
>
> Indeed, that () does not make sense (to me).
>
How about this:
"Calculates the annual return on a treasury bill (to me)"? ;‑)
Regards,
Czesław
---------------------------------------------------------------------
To unsubscribe, e-mail: l10n-unsubscribe@openoffice.apache.org
For additional commands, e-mail: l10n-help@openoffice.apache.org
Re: "()" in the description of the TBILLEQ function
Posted by Matthias Seidel <ma...@hamburg.de>.
Hi,
Am 17.08.22 um 09:03 schrieb Czesław Wolański:
> Hi,
>
> Help for Calc,
> Financial Functions Part Two, the TBILLEQ function:
>
> TBILLEQ
> "Calculates the annual return on a treasury bill ().
Indeed, that () does not make sense (to me).
Regards,
Matthias
> A treasury bill is purchased on the settlement date and sold at the full
> par value on the maturity date,
> that must fall within the same year. A discount is deducted from the
> purchase price."'
>
>
> What is the purpose of "()" in the first sentence of the above description?
>
>
> Regards,
> Czesław
>
>
> LINKS:
>
> [1]
> Pootle, Help,
> location: 04060119.xhp#par_id3154403.59.help.text
>
> <ahelp hid="HID_AAI_FUNC_TBILLEQ">Calculates the annual return on a
> treasury bill ().</ahelp>
>
>
> [2]
> AOO Wiki, documentation/How Tos/Calc:
> https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_TBILLEQ_function
>
> TBILLEQ
> "Returns the bond-equivalent-yield (BEY) for a US Treasury bill.
> [...]
> Issues:
> This function may assist with US Treasury bills if used carefully. The
> underlying formula may not apply to Treasury bills issued by other
> governments."
>
>
> [3]
> Calc Guide (OpenOffice.org 3.3),
> Appendix B Description of Functions,p. 391
>
> TBILLEQ - "Calculates the annual return on a treasury bill."
>