[{"id":"1b88a165-2563-437e-99bb-ae30bd4b56db","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"a244ead7-a2c6-47a3-ac17-c5dbfa337362","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"33638a1c-7196-42c1-a96d-38b2d9ba8ac4","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"8e72e33e-b4ab-4fb3-98fc-a0b148134aed","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"86662220-9b9e-4940-9ced-d22642ea49a8","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"55fd3bb8-18d4-4edb-9640-ca3a365b798f","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"760b37c7-c713-4b24-b9ba-4bfe7d8437a6","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"3a083583-1d5f-492b-b450-34b2b5c775b8","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"04e73782-aa78-4dfe-a4f9-e72ed4c78a11","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"57c94653-8893-403b-a5b1-0d1e33a0bd0f","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"09a66339-64c0-415c-b142-0691587a8e4a","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"5b7aeac5-c755-426a-95c7-1ae8e547179a","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"790bc77a-9216-48fd-b8f9-fbc374ebb155","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"900e6cab-065d-4f1c-844d-efa3c074e270","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"0baaf91d-84f6-404c-a487-735226b6d5b6","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"5d37413b-3600-4da9-9700-feea54355f59","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"7ded3a22-15eb-49b8-a488-e83c2cd872eb","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"89c707ed-9841-4e53-96fb-940cc3214804","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"a570c8e7-07a2-47da-965b-da44fd1fa5cf","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"a5a73576-16ea-4cbc-925c-ef547389eaa5","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"69e79655-e015-4f9a-a230-2a25c988c926","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"adf3817f-7667-4a4c-8a5f-767b0b7e1e3e","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"1126cfab-6210-4e28-bee0-02c113fb7a0c","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"63c577e6-6cf9-497e-94e1-2307f7d3f498","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"24769ecd-2b08-4a85-b318-4f533bbf8393","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"2605431b-dc80-491d-886e-28981595d277","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"4f41e22e-eb51-49e5-aeae-a42dd6bf352c","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"aa71a884-c5bc-4842-8d6a-873dfd645167","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"b0576ca2-cb84-4390-9f95-9354ec20eda5","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"dacc7931-6785-4675-be31-80930403cf7b","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"c90d5fdf-420f-4978-8bf5-c9a2bb4334b3","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"6e6ac5b1-1501-4e28-89cc-525139488537","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"ff052704-1389-4029-bcdd-73c6cbe9f807","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"21c6131f-0f2d-41d1-9284-6ad9ee803c1f","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"64e2f4a3-2303-4bfa-8a93-6c23ef01de58","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"4a0842a3-20b1-40c3-8e00-cd5941ffdf53","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]}]
Spread 提供以下财务函数,按字母顺序排列
函数 | 描述 |
---|---|
ACCRINT | 此函数计算支付定期利息的证券的应计利息。 |
ACCRINTM | 此函数计算定期支付利息的证券到期时的应计利息。 |
AMORDEGRC | 此函数返回会计期间的折旧,考虑按比例折旧,并在基于资产寿命的计算中应用折旧系数。 |
AMORLINC | 此功能计算会计期间的折旧,同时考虑按比例折旧。 |
COUPDAYBS | 此函数计算从息票期开始到结算日的天数。 |
COUPDAYS | 此函数返回包含结算日期的息票期中的天数。 |
COUPDAYSNC | 此函数计算从结算日期到下一个息票日期的天数。 |
COUPNCD | 此函数返回结算日期之后的下一个息票日期的日期编号。 |
COUPNUM | 此函数返回结算日和到期日之间到期的息票数量。 |
COUPPCD | 此函数返回结算日期之前的前一个息票日期的日期编号。 |
CUMIPMT | 此函数返回在开始和结束期间为贷款支付的累计利息。 |
CUMPRINC | 此函数返回在开始和结束期间为贷款支付的累积本金。 |
DB | 此函数使用固定余额递减法计算指定期间的资产折旧。 |
DDB | 此函数使用双倍余额递减法或您指定的其他方法计算指定期间的资产折旧。 |
DISC | 此函数计算证券的贴现率。 |
DOLLARDE | 此函数将分数美元价格转换为十进制美元价格。 |
DOLLARFR | 此函数将十进制数字美元价格转换为分数美元价格。 |
DURATION | 此函数返回假定面值为 100 美元的麦考利久期。 |
EFFECT | 此函数计算给定名义年利率的有效年利率和每年的复利期数。 |
FV | 此函数根据现值、定期付款和指定的利率返回投资的未来价值。 |
FVSCHEDULE | 此函数在应用一系列复利后返回初始本金的未来值。计算具有可变或可调整利率的投资的未来价值。 |
INTRATE | 此函数计算完全投资证券的利率。 |
IPMT | 此函数计算贷款利息的支付。 |
IRR | 此函数返回由数组中的数字表示的一系列现金流的内部收益率。 |
ISPMT | 此函数计算特定投资期间支付的利息。 |
MDURATION | 此函数计算假定面值为 100 美元的证券的修正麦考利久期。 |
MIRR | 此函数返回一系列定期现金流量的修正内部收益率。 |
NOMINAL | 此函数返回给定有效利率和每年复利期数的名义年利率。 |
NPER | 此函数根据现值、未来值、定期付款和指定的利率返回投资的周期数。 |
NPV | 此函数通过使用贴现率和一系列未来付款和收入来计算投资的净现值。 |
ODDFPRICE | 此函数计算具有奇数第一期的证券每 100 美元面值的价格。 |
ODDFYIELD | 此函数计算具有奇数第一期的证券的收益率。 |
ODDLPRICE | 此函数计算每张面值为 100 美元且最后票息期为奇数的证券的价格。 |
ODDLYIELD | 此函数计算最后一个周期为奇数的证券的收益率。 |
PDURATION | 此函数返回投资达到指定值所需的期间数。 |
PMT | 此函数返回给定现值、指定利率和期限数的贷款的支付金额。 |
PPMT | 此函数返回给定现值、指定利率和期限数的贷款本金支付金额。 |
PRICE | 此函数计算定期利息证券每 100 美元面值的价格。 |
PRICEDISC | 此函数返回每 100 美元面值的折扣证券的价格。 |
PRICEMAT | 此函数返回每 100 美元面值的支付利息的证券到期时的价格。 |
PV | 此函数根据利率、定期付款的数量和金额以及未来价值返回投资的现值。现值是一系列未来付款现在值得的总金额。 |
RATE | 此函数返回年金每期的利率。 |
RECEIVED | 此函数返回在到期时收到的全额投资证券的金额。 |
RRI | 此函数返回投资增长的等价利率。 |
SLN | 此函数返回资产在一个时期内的直线折旧。 |
SYD | 此函数返回资产在指定时期内的年数总和折旧。 |
TBILLEQ | 此函数返回国库券(或国库券)的等效收益率。 |
TBILLPRICE | 此函数返回国库券(或国库券)每 100 美元面值的价格。 |
TBILLYIELD | 此函数返回国库券(或国库券)的收益率。 |
VDB | 此函数返回您使用可变余额递减法指定的任何期间的资产折旧。 |
XIRR | 此函数计算可能不是周期性的现金流量表的内部收益率。 |
XNPV | 此函数计算可能不是周期性的现金流量表的净现值。 |
YIELD | 此函数计算定期支付利息的证券的收益率。 |
YIELDDISC | 此函数计算折扣证券的年收益率。 |
YIELDMAT | 此函数计算在到期时支付利息的证券的年收益率。 |