Price

Facebooktwittergoogle_plusredditpinterestlinkedinmailby feather


——————————————————————————————————————————————————
Support machine translation: http://amzn.to/1Z7d5oc
——————————————————————————————————————————————————
Crystal Reports Online Help
Price
Basic and Crystal syntax.
Overloads
Price (settlementDate, maturityDate, couponRate, yield, redemptionValue, frequency)
Price (settlementDate, maturityDate, couponRate, yield, redemptionValue, frequency, basis)
Arguments
settlementDate is a Date or DateTime specifying when the security was purchased.
maturityDate is a Date or DateTime after the settlement date specifying when the security matures.
couponRate is a non-negative number specifying the interest rate for the security.
yield is a non-negative number specifying the security’s yield.
redemptionValue is a number or currency specifying the security’s value at redemption per $100 of face value.
frequency is a number specifying the number of coupons per year. The supported values are 1 (annual payments), 2 (semiannual payments), and 4 (quarterly).
basis is an optional number specifying the day basis system to use. The following types are supported:
0 – American 30/360 (default)
1 – actual/actual
2 – actual/360
3 – actual/365
4 – European 30/360
Returns
Currency value
Action
Price returns the price of a security that pays interest periodically per $100 of face value. There are three parts to the calculation. The first term calculates the present value of the redemption price, the second term handles the present value of the coupon payments and the last term subtracts the accrued interest payments.
Examples
The following example is applicable to both Basic and Crystal syntax:
Suppose a municipal bond is purchased on March 1, 1999 with a maturity date of January 1, 2005. The interest rate is 6.7% and the yield is 6.5%. At redemption, the face value of the bond is returned for a value of $100 and the interest is paid out quarterly.
Price(DateValue(1999,3,1), DateValue(2005,1,1), 0.067, 0.065, 100, 4, 0)Returns $100.96 (rounded to the nearest cent) as the bond’s price.
Comments
This function is similar to the Excel function of the same name.
See Also
PriceDisc
PriceMat
Yield
YieldDisc
YieldMat
——————————————————————————–

Previous page Next page
SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/


————————————————– ————————————————– ————————————————–
Appoġġ ta ‘traduzzjoni awtomatika: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–
Rapporti Crystal Online Għajnuna
prezz
Bażiku u Crystal sintassi.
kariki żejda
Prezz (settlementDate, maturityDate, couponRate, rendiment, redemptionValue, frekwenza)
Prezz (settlementDate, maturityDate, couponRate, rendiment, redemptionValue, il-frekwenza, abbażi)
argumenti
settlementDate hija data jew li tispeċifika DateTime meta l-garanzija kien mixtri.
maturityDate hija data jew DateTime wara d-data tal-ħlas li jispeċifikaw meta l-garanzija jimmatura.
couponRate huwa numru mhux negattiv li tispeċifika r-rata ta ‘imgħax għas-sigurtà.
rendiment huwa numru mhux negattiv li tispeċifika rendiment tal-garanzija tal.
redemptionValue huwa numru jew munita li tispeċifika valur tal-garanzija tal-fidi għal kull $ 100 tal-valur nominali.
frekwenza huwa numru jispeċifika n-numru ta ‘kupuni fis-sena. Il-valuri appoġġati huma 1 (pagamenti annwali), 2 (pagamenti kull sitt xhur), u 4 (kull tliet xhur).
bażi huwa numru fakultattiva jispeċifika s-sistema bażi jum għall-użu. It-tipi li ġejjin huma appoġġjati:
0 – Amerikana 30/360 (default)
1 – attwali / attwali
2 – attwali / 360
3 – attwali / 365
4 – Ewropea 30/360
denunzji
valur munita
azzjoni
Prezz jirritorna l-prezz ta ‘titolu li jħallas l-imgħaxx perjodikament għal kull $ 100 tal-valur nominali. Hemm tliet partijiet għall-kalkolu. L-ewwel mandat tikkalkula l-valur preżenti tal-tifdija, it-tieni terminu juża l-valur preżenti tal-ħlasijiet ta ‘kupuni u l-aħħar terminu inaqqas il-pagamenti ta’ imgħax dovuti.
eżempji
L-eżempju li ġej huwa applikabbli kemm sintassi Bażiku u Crystal:
Ejja ngħidu bond muniċipali jinxtara fuq Mar 1, 1999 b’data ta ‘maturità ta’ Jannar 1, 2005. Ir-rata ta ‘imgħax hija 6.7% u l-produzzjoni hija 6.5%. Tal-fidi, il-valur nominali tal-bond huwa rritornat għal valur ta ‘$ 100 u l-imgħax jitħallas kull tliet xhur.
Prezz (DateValue (1999,3,1), DateValue (2005,1,1), 0.067, 0.065, 100, 4, 0) Denunzji $ 100.96 (aġġustat għall-eqreb ċenteżmu) bħala prezz tal-bond.
kummenti
Din il-funzjoni hija simili għall-funzjoni Excel ta ‘l-istess isem.
Ara ukoll
PriceDisc
PriceMat
rendiment
YieldDisc
YieldMat
————————————————– ——————————

paġna ta ‘qabel paġna li jmiss
SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
servizzi ta ‘appoġġ
http://service.sap.com/bosap-support/
Dokumentazzjoni prodott fuq il-Web
http://help.sap.com/
 


————————————————– ————————————————– ————————————————–
Ondersteuning masjien vertaling: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–
Crystal Reports Online Hulp
prys
Basiese en Crystal sintaksis.
oorlaai
Prys (settlementDate, maturityDate, couponRate, opbrengs, redemptionValue, frekwensie)
Prys (settlementDate, maturityDate, couponRate, opbrengs, redemptionValue, frekwensie, basis)
argumente
settlementDate is ‘n datum of Datum tyd spesifiseer wanneer die sekuriteit is aangekoop.
maturityDate is ‘n datum of Datum tyd ná die vereffeningsdatum spesifiseer wanneer die sekuriteit verval.
couponRate is ‘n nie-negatiewe getal spesifiseer die rentekoers vir die veiligheid.
opbrengs is ‘n nie-negatiewe getal spesifiseer opbrengs die sekuriteit se.
redemptionValue is ‘n aantal of valuta spesifiseer waarde die sekuriteit se verlossing per $ 100 sigwaarde.
frekwensie is ‘n aantal spesifiseer die aantal koepons per jaar. Die ondersteun waardes is 1 (jaarlikse betalings), 2 (half jaar betalings), en 4 (kwartaallikse).
basis is ‘n opsionele getal spesifiseer die dag basis stelsel om te gebruik. Die volgende tipes word ondersteun:
0 – Amerikaanse 30/360 (verstek)
1 – werklike / werklike
2 – werklike / 360
3 – werklike / 365
4 – Europese 30/360
opbrengste
geldeenheid waarde
Aksie
Prys gee die prys van ‘n sekuriteit wat belang van tyd tot tyd per $ 100 sigwaarde betaal. Daar is drie afdelings vir die berekening. Die eerste kwartaal word bereken dat die huidige waarde van die verlossing prys, die tweede kwartaal hanteer die huidige waarde van die koepon betalings en die laaste kwartaal trek die rente betalings.
voorbeelde
Die volgende voorbeeld is van toepassing op beide basiese en Crystal sintaksis:
Veronderstel ‘n munisipale band gekoop op 1 Maart 1999 met ‘n vervaldatum van 1 Januarie 2005. Die rentekoers is 6.7% en die opbrengs is 6,5%. Op verlossing, is die nominale waarde van die band terug vir ‘n waarde van $ 100 en die rente word kwartaalliks uitbetaal.
Prys (DATEVALUE (1999,3,1), DATEVALUE (2005,1,1), 0,067, 0,065, 100, 4, 0) gee terug $ 100,96 (afgerond tot die naaste sent) as prys die band se.
kommentaar
Hierdie funksie is soortgelyk aan die Excel-funksie met dieselfde naam.
Sien ook
PriceDisc
PriceMat
opbrengs
YieldDisc
YieldMat
————————————————– ——————————

Vorige Volgende
SAP Business
http://www.sap.com/sapbusinessobjects/
ondersteuningsdienste
http://service.sap.com/bosap-support/
Produk dokumentasie op die web
http://help.sap.com/
 


————————————————– ————————————————– ————————————————–
Mbështetje makinë përkthim: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–
Crystal Reports Online Ndihmë
çmim
Basic dhe Crystal sintaksë.
mbingarkesa
Çmimi (settlementDate, maturityDate, couponRate, rendimenti, redemptionValue, frekuenca)
Çmimi (settlementDate, maturityDate, couponRate, rendimenti, redemptionValue, frekuenca, baza)
argumentet
settlementDate është një Date ose DateTime specifikuar kur siguria është blerë.
maturityDate është një Date ose DateTime pas datës së shlyerjes specifikuar kur maturohet siguria.
couponRate është një numër jo-negative specifikuar normën e interesit për sigurinë.
Japin është një numër jo-negativ specifikuar rendimentin e Sigurimit.
redemptionValue është një numër apo monedhë specifikuar vlerën e Sigurimit në shpengim për 100 $ e vlerë nominale.
Frekuenca është një numër specifikuar numrin e kuponat në vit. Vlerat e mbështetura janë 1 (pagesat vjetore), 2 (pagesa gjysmëvjetore), dhe 4 (tremujore).
Baza është një numër fakultative specifikuar sistemin baza ditore për të përdorur. Llojet e mëposhtme janë të mbështetur:
0 – American 30/360 (default)
1 – aktuale / aktual
2 – aktuale / 360
3 – aktuale / 365
4 – European 30/360
Kthim
vlera e monedhës
veprim
Çmimi kthen çmimin e një të sigurisë që paguan interes periodikisht per 100 $ e vlerë nominale. Ka tri pjesë të llogaritjes. Termi i parë llogarit vlerën aktuale të çmimit të shpengimit, termi i dytë merret me vlerën aktuale të pagesave kupon dhe afati i fundit zbret pagesat e interesit e përllogaritur.
shembuj
Shembulli i mëposhtëm është i aplikueshëm për të dy Themelore dhe Crystal sintaksë:
Supozoni një lidhje komunale është blerë më 1 mars, 1999 me një datë maturimi 1 janar 2005. Norma e interesit është 6.7% dhe rendimenti është 6.5%. Në shpengimit, vlera nominale e obligacionit është kthyer për një vlerë prej $ 100 dhe interesi paguhet çdo tre muaj.
Çmimi (DateValue (1999,3,1), DateValue (2005,1,1), 0,067, 0.065, 100, 4, 0) Kthen $ 100,96 (rrumbullakuar të afërt qind), si çmim lidhja së.
Comments
Ky funksion është i ngjashëm me funksionin Excel me të njëjtin emër.
Shiko gjithashtu
PriceDisc
PriceMat
Hapni rrugën
YieldDisc
YieldMat
————————————————– ——————————

Facebooktwittergoogle_plusredditpinterestlinkedinmailby feather