Sheetgo Blog

With the DISC formula in Google Sheets, we can calculate a security's discount rate based on its price. This is one of the myriads of Financial formulas that Google Sheets is ported with. Syntax DISC(settlement, maturity, price, redemption, [day_count_convention])...

Do you need to calculate the number of compounding periods that an investment required to reach a target value? The DURATION formula in Google Sheets can help us with that. It considers the present value of an investment as well as the rate of appreciation to arrive...

With the NOMINAL formula in Google Sheets, we can calculate the annual nominal interest rate. We just need to have the effective interest rate per annum and the number of compounding periods per year. Nominal interest rate usually refers to the interest rate before...

Do you have a series of irregularly spaced cash flows of an investment? And you want to calculate the internal rate of return or annualized yield for that investment without the hassles of using complicated math? To our rescue, we have XIRR formula in Google...

At some point in time, we get curious as to what is the today's value of an investment we are committing to. The NPV formula in Google Sheets helps us with just that. All we need to have with us is a series of periodic investments and the discount rate for input...

What is Visible? Ever wanted to visualize Google sheets data, creating dashboard views and generate appealing reports? Visible is a SaaS company that allows you to create dashboards views and graphs from multiple sources. Google sheets are one of the data sources you...

Europe's General Data Protection Regulation (GDPR) is a new law governing data protection and privacy for citizens of the European Union. Its aim is to give individuals control over their data and simplify existing regulations. GDPR becomes enforceable on May 25th...

Your company has decided to standardize spreadsheets and reporting on Google Sheets. That’s great, but first you need to get the data you want to report on. If that data resides on the web, then you can get it with data extraction. Data extraction is sometimes...

Unlike other desktop-based spreadsheets, Google Sheets is a cloud-based application that is ubiquitous. It is location and device independent. All we need is a browser and an Internet connection. With such a grand proposition of being able to serve people all over the...

Google Sheets primarily helps us handle information. In fact, a lot of it. Besides providing us with tools that helps us reorganize, manipulate, analyze and summarize metrics. Because this cloud based application lets us store huge data, the concept of worksheets...

We know how resourceful Google sheets can be in our day to day lives. It boosts our productivity and makes the activity of storing, sharing the information a breeze. It is already a comprehensive application with myriad of standard spreadsheet related tools and...

We most commonly use Google Sheets to store data and share it with others. Among other things it also lets us manipulate the data, analyze it and accordingly establish trends etc. For a regular user, the tasks can get repetitive and time-consuming, and not forget...