BFX Function – Bringing market data to your spreadsheets - Bitfinex blog
post-template-default,single,single-post,postid-19075,single-format-standard,bridge-core-3.0.6,et_bloom,qode-page-transition-enabled,ajax_fade,page_not_loaded,,qode-title-hidden,qode_grid_1300,footer_responsive_adv,qode-content-sidebar-responsive,qode-child-theme-ver-1.0.0,qode-theme-ver-29.3,qode-theme-bridge,qode_header_in_grid,wpb-js-composer js-comp-ver-6.10.0,vc_responsive

BFX Function – Bringing market data to your spreadsheets

We know that fast and accurate market data is one crucial aspect of trading, especially for Algorithmic traders and high-frequency traders. That’s why we made our market data accessible for the public through the Bitfinex APIs. 

We’ve developed BFX Function for you, to showcase how Bitfinex market data can be used to bring data to your Excel spreadsheet, and be adapted to your own needs. BFX Function is an add-in that uses custom functions to retrieve specific bits of data you want into Excel spreadsheets. It works by parsing market data from the API into a familiar table structure on Excel. 

BFX Function has various formulas to provide you with different information, such as historical prices, ticker data, and candle data. You can find the complete list on the downloadable cheat sheet file.

Here are some of the things you can do with BFX Function:

  • Read market data 

With BFX Function, you can parse data into an easier-to-read format on Excel. The tickers data from the API looks like this: 


The data will look like this with BFX Function:

  • Determine the approximate value of your portfolio at a given time

Finding out how much your crypto portfolio is worth in value can take a while; however, with REST API, you can get this information instantly. You’d need to build each query and then look for the right field in the returned data to get the information you want. This data can then be used in websites, mobile apps or just a spreadsheet for your personal use.

BFX Function simplifies the process by making a table on Excel and quickly parsing your queries for each currency you have.

  • Keep track of market indicators

Staying on top of the market takes a lot of work. BFX function includes options to automatically calculate market sentiment indicators such as the ratio between longs and shorts. It’s easy to build a table to track these over time.

  • Expand the custom function with your own calculation

You can expand BFX Function with your own custom fields to accommodate any calculations you regularly perform with our API’s data with ease.

Find out how to do it on the Showcase page of our API documentation.  

Visit to download BFX Function and get started!

BFX Function is just an example of the possible usage of the Bitfinex APIs data, visit Bitfinex API Showcase for more. Lastly, we’d love to hear from you!

Please leave your feedback on BFX Function by filling this form.