Build your first formula

Using SheetsFinance is as simple as entering the correct formula into a Google Sheets or Excel cell. You can either use our functions directly or use our super handy Function Generator to build the functions for you. Examples for both are shown below.

Direct Function

1. Open up a new Google Sheet or Excel Workbook

2. Click on a cell

3. Enter the following:

=SF("AAPL","realTime","price")

Once loaded you should see Apple Inc.'s (AAPL) current price.

Even more simply you can do the following:

=SF("AAPL")

This will also result in Apple Inc.'s (AAPL) current price as the default return of the SF() function is the real-time current price of the stock, ETF, cryptocurrency or FOREX rate.

Use our Symbol Search to find the correct stock, ETF, FOREX or crypto code.

See Available Functions for details on all available functions.

See Performance Tips for tips on optimising your use of SheetsFinance functions.

Function Generator

1. Enter AAPL in cell A1.

2. Open our Function Generator from the add-on drop down in Google Sheets or in Excel, click the main SheetsFinance logo in the ribbon menu.

   

3. Fill out the fields in the Function Generator like so:

• Insert into Cell - B1 (Note: Leaving this blank is totally fine. The formula will instead be inserted into the currently selected cell in Google Sheets or Excel)

• Ticker Cell - A1

• Select Real-time/Historical

• Type - Real-time

• Metrics - Price

  

4. Click Generate

Once loaded you should see Apple Inc.'s (AAPL) current price in cell B1.

5. Now type V into cell A2

6. Drag down the function that was generated in B1 to cover B2

Once loaded you should see Visa Inc.'s (V) current price in cell B2

See Function Generator for detailed use.