How to use the Foundry USA Pool and API Keys with Microsoft Excel?

Connecting your Group Accounts or Sub-Account's API Keys to Microsoft Excel

Select the "Advanced" radio button.

• Fill in the other details like in the screenshot below.
• The first URL part is the API endpoint.
  • For example: https://api.foundryusapool.com/subaccount_hashrate_day/{subAccountName}
• The second URL part is the first parameter and should start with question mark.
  • For example: ?coin=BTC
• The rest of the URL parts are the rest of the parameters and must start with &.
  • For example: &startDateUnixMs=1616000400000
• In the “HTTP request header parameters” section, enter “X-API-KEY” in the first field then your actual API key in the second field.
• Click OK

 

Click “To Table”

 

Leave the settings default (shown below) and click ok.