free page hit counter


BFX Feature – Bring market data to your spreadsheets

We know that fast and accurate market data is a critical aspect of trading especially for algorithmic traders and high frequency traders. That’s why we’ve made our market data accessible to the public through the Bitfinex APIs.

We have developed BFX function for you, to show you how Bitfinex market data can be used to bring data into your Excel spreadsheet and be customized to your own needs. BFX Function is an add-in that uses custom functions to retrieve specific pieces of data you want in Excel spreadsheets. It works by parse market data from the API into a known table structure in Excel.

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

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

The BFX function allows you to parse data into an easier-to-read format in Excel. The tickers data from the API looks like this:

[[“tBTCUSD”,34517,13.317734950000002,34531,16.28784829,2549,0.0797,34525,30866.02464789,36656,30635],[“tLTCUSD”,139.69,1905.2891424600002,139.96,1263.1943379500003,15.26,0.1226,139.69,467362.50572258,147.35,112.75],[“tLTCBTC”,0.0040508,1407.61814708,0.0040543,1548.2158999900003,0.0001652,0.0424,0.0040651,49702.702695,0.004076,0.0037],[“tETHUSD”,1085.2,435.67057708,1085.9,532.82962583,95.4,0.0964,1085.4,362308.26429979,1150.5,923]]

The data looks like this with the BFX function:

  • Determine the estimated value of your portfolio at any given time

It may take a while to find out how much your crypto wallet is worth; However, with REST API you can request this information directly. You need to build each query and then find the appropriate 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 personal use.

The BFX function simplifies the process by creating a table in Excel and quickly analyzing your questions for any currency you have.

  • Keep track of market indicators

Keeping up to date with the market takes a lot of work. The BFX function includes options to automatically calculate market sentiment indicators such as the ratio of longs to shorts. It’s easy to build a table to track it over time.

  • Expand the custom function with your own calculation

You can extend the BFX function with your own custom fields to easily handle all the calculations you perform regularly with the data from our API.

Read how to do this on it Showcase page of our API documentation.

Visit https://github.com/bitfinexcom/bfx-api-excel-demo to download BFX feature and get started! BFX function is just one example of the possible use of the Bitfinex API data, visit Bitfinex API Showcase for more. Finally, we would love to hear from you! Please provide your feedback on BFX feature by completing this shape.



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *