BFX Function – Bring Market Data to Your Spreadsheets

[ad_1]

BFX Function – Bring Market Data to Your Spreadsheets

We know that fast and accurate market data is a crucial aspect of trading, especially for algorithmic traders and high frequency traders. This is why we have made our market data accessible to the public via the Bitfinex APIs.

we have developed BFX function for you, to show how Bitfinex market data can be used to bring data to your Excel spreadsheet and be tailored to your own needs. The BFX function is an add-in that uses custom functions to retrieve specific bits of data that you want in Excel worksheets. It works by analyzing API market data in a familiar table structure on Excel.

BFX Function offers different 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 memory aid drop off.

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

With the BFX function, you can analyze the data in an easier to read format in Excel. The API ticker data 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 will look like this with the BFX function:

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

Determining the value of your cryptocurrency portfolio can take some time; However, with the REST API, you can get this information instantly. You need to build each query and then find the correct 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.

The BFX function simplifies the process by creating a table in Excel and quickly analyzing your queries for each currency you own.

  • Track market indicators

Staying on top of the market takes a lot of work. The BFX feature includes options to automatically calculate market sentiment indicators such as the ratio of long to short positions. It’s easy to create a table to track them over time.

  • Expand the custom function with your own calculation

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

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

Visit https://github.com/bitfinexcom/bfx-api-excel-demo to download BFX Function and get started!

The BFX function is just one example of the possible use of data from Bitfinex APIs, visit Introducing the Bitfinex API for more. Finally, we would love to hear from you!

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

[ad_2]

Source Link