Build a cryptocurrency arbitrage spreadsheet in under 10 minutes!

Discussion in 'Blockchain & Cryptocurrency Mining' started by poony, Jul 1, 2019.

  1. poony

    poony Member

    Joined:
    Dec 16, 2005
    Messages:
    17
    Location:
    Melbourne
    Hey everyone!
    I created a video that demonstrates how to use Excel to build a cryptocurrency arbitrage spreadsheet.



    This is a great use case to learn the following Excel formulas:
    WEBSERVICE to download the information from cryptocurrency exchanges.
    MID and FIND to extract the buy/bid and sell/ask price from each exchange.
    MIN and MAX to identify the cheapest and most expensive prices.
    INDEX, MATCH, OFFSET to to identify the exchange name with the cheapest and most expensive prices.
    IF to determine any arbitrage opportunities based on a percentage gain.

    Let me know if you have any questions!
     
    doug81, pezzy and whatdoesthisdo like this.
  2. doug81

    doug81 Member

    Joined:
    Jul 18, 2005
    Messages:
    4,554
    Location:
    Santiago, Chile
    Connect this to an autotrading exchange and you're a crypto-quant :thumbup:
     

Share This Page

Advertisement: