Financial
DISC
Returns the discount rate of a security. Syntax DISC(settlement; maturity; price; redemption_value; [basis]) settlement: Date of purchase of the security. Eg., "2/1/2018" maturity: Date on which the security matures. Eg., "4/12/2018" price: The ...
DDB
Returns the depreciation of an asset for a specified period using the double declining-balance method, or another method that you specify. Syntax DDB(original_cost; salvage; lifetime; year; [factor]) original_cost: The initial cost of the asset. ...
DB
Returns the depreciation of an asset for a specified period using the fixed rate declining-balance method. Syntax DB(original_cost; salvage; lifetime; year; [months]) original_cost: The initial cost of the asset. Eg., 50000 salvage: The value at ...
CURRENCY
Converts the given value from one currency to another specified currency value. Syntax CURRENCY(value; "from"; "to") value: The value to be converted. Eg., 3500 from: The currency from which the value is to be converted. Must be given as a ...
CUMPRINC
Returns the total capital repaid on a loan in a specified period. Syntax CUMPRINC(rate; nper; pv; start; end; type) rate: The interest rate per period. Eg., A2 nper: The total number of payment periods in the term. Eg., 15 pv: The initial sum ...
CUMIPMT
Returns the cumulative interest paid on a loan in a specified period. Syntax CUMIPMT(rate; nper; pv; start; end; type) rate: The interest rate per period. Eg., A2 nper: The total number of payment periods in the term. Eg., 15 pv: The initial sum ...
COUPPCD
Returns the coupon or interest payment date that precedes the settlement date. Syntax COUPPCD(settlement; maturity; frequency; [basis]) settlement: Date of purchase of the security. Eg., "2/1/2018" maturity: Date on which the security matures. ...
COUPNUM
Returns the number of coupons, or interest payments, between the settlement date and the date of maturity. Syntax COUPNUM(settlement; maturity; frequency; [basis]) settlement: Date of purchase of the security. Eg., "2/1/2018" maturity: Date on ...
COUPNCD
Returns the next coupon date that comes after the settlement date. Syntax COUPNCD(settlement; maturity; frequency; [basis]) settlement : Date of purchase of the security. Eg., "2/1/2018" maturity : Date on which the security matures. Eg., ...
COUPDAYSNC
Returns the number of days between the settlement date and the next coupon date. Syntax COUPDAYSNC(settlement; maturity; frequency; [basis]) settlement: Date of purchase of the security. Eg., "2/1/2018" maturity: Date on which the security ...
COUPDAYS
Returns the number of days in the coupon period that includes the settlement date. Syntax COUPDAYS(settlement; maturity; frequency; [basis]) settlement: Date of purchase of the security. Eg., "2/1/2018" maturity: Date on which the security ...
COUPDAYBS
Returns the number of days between the beginning of the coupon period and the settlement date. Syntax COUPDAYBS(settlement; maturity; frequency; [basis]) settlement: Date of purchase of the security. Eg., "2/1/2018" maturity: Date on which the ...
AMORLINC
Returns depreciation for a period using linear amortization. Considers a proportional depreciation amount if the capital asset is purchased during the settlement period. Syntax AMORLINC(cost; purchase_date; first_period_end; salvage; period; ...
AMORDEGRC
Returns depreciation for a period using degressive amortization (French system). Unlike AMORLINC, it uses a depreciation coefficient that is independent of the depreciable period. Syntax AMORDEGRC(cost; purchase_date; first_period_end; salvage; ...
ACCRINTM
Calculates the accrued interest for a security that pays at maturity. Syntax ACCRINTM(issue; settlement; rate; par; [basis]) issue: The issue date of the security. Eg., "2/1/2018" settlement: The maturity date of the security. Eg., "12/13/2018" ...
ACCRINT
Calculates the accrued interest for a security with periodic interest payments. Syntax ACCRINT(issue; first_interest; settlement; rate; par; frequency; [basis]) issue: The issue date of the security. Eg., "2/1/2018" first_interest: The first ...

Access your files securely from anywhere

Start tracking your website metrics today

Use PageSense to understand what your visitors are looking for, how they are behaving, and where they are facing problems on your website.

Ready to improve your website's performance?

Install the PageSense code snippet on your site in a matter of minutes and start collecting in-depth data about the website visitors to grow your business.

Track and measure every business goal

Set up goals in PageSense to measure every single action performed by visitors on your website like button or link clicks, form submissions, and page engagements.

Understand the customer journey on your website

Create funnels in PageSense to quickly see which pages visitors use to enter your website, where they navigate to next, and which pages they decide to leave without converting.

Visualize your visitor's behavior with color codes

Set up heatmaps in PageSense to see where users have clicked more, how far they've scrolled, and on which parts of a page they've spent the most time using color-coded patterns in reports.

Measure customer engagement with your web forms

Use form analytics in PageSense to see how people interact with different fields in your form, whether they complete the form successfully or not, and where exactly they drop out on your form.

Record real visitor interactions on your website

Use session recordings in PageSense to watch a video of all the visitor actions performed on your website including the pages they navigate, the buttons they click, the UX issues they face, and more.

Test and optimize webpages for better conversions

Run A/B or Split URL tests in PageSense to figure out which version of your web page works best for your business and results in the best conversion rate.

Give each customer a unique website experience

Use personalization in PageSense to deliver customized versions of your website for every individual customer based on their demographics, local weather, browsing history, and more.

Grow your business through customer feedback

Run polls on your website using PageSense to understand what your customers think about your products/services and what needs improvement on your site.

Send timely updates that customers love

Use web push notifications in PageSense to schedule and notify your customers about an upcoming flash sale, product releases, promotional coupons, and a lot more that can spark conversions on your website.

Advertise your business to website visitors

Use pop-ups in PageSense to instantly grab the attention of visitors by showing attractive signup offers, coupon code discounts, or email newsletters that can eventually convert them into subscribers.

Access more advanced settings in PageSense

Use PageSense's advanced features like creating mutually exclusive groups, enabling cross-domain tracking, configuring customized project JS, and more to get deeper insights about your website.

Try easy-to-use extensions

Download the PageSense extension app available for your web browser with a few clicks and start collecting all of your required website metrics in real time.

Discover your favorite integrations with PageSense

Get a deeper look at your website's data by seamlessly integrating PageSense with a host of popular third-party apps like Google Analytics, Mixpanel, Intercom, and more.