1. With Barchart for Excel you have several options for adding Futures and Currency market data.  To start, click on the Futures icon in the Barchart for Excel ribbon.

Step 1 image

2. There are several tables to choose from, including an Overview with major contracts, as well as sector specific tables like Energies and Grains.  Let's select Commodities Overview and click Insert.

Step 2 image

3. Here is the Commodities Overview table featuring the most popular North American futures contracts.  From here you can customize this table using native Excel functionality.

Step 3 image

4. Let's take a look at some of the other data tables within the Futures section.  Under Market Pulse, let's select Performance Leaders and then change the period to 1-Month.

Step 4 image

5. Here are the different time periods you can choose from.  Select 1-Month then click Insert.

Step 5 image

6. And here is the Performance Leaders table for Futures.  You will see both Bullish and Bearish trends are provided.

Step 6 image

7. Next let's take a look at the market data available within the Currencies section.  Click the Currencies icon.

Step 7 image

8. The Currency window presents a variety of choices, including Popular Cross Rates, individual currencies, leaderboards and market pulse options.  Let's select Popular Cross Rates and then click Insert.

Step 8 image

9. Here is the Popular Cross rates table, instantly displayed in Barchart for Excel.  

Step 9 image

10. Market data for cryptocurrencies is also available within Barchart for Excel.  Let's select Popular Coins and then click Insert.

Step 10 image

11. You will see a variety of cryptocurrencies are presented and are quoted in terms of other currencies.  You will also find there are a variety of additional data tables available for currencies.

Step 11 image

12. In addition to using Lists to display Futures and Currency market data, you can also use the Quote function.  Click the Quote icon in the Barchart for Excel ribbon.

Step 12 image

13. Let's search for Corn and then double click the ZCN21 symbol for July 2021 Corn Futures.

Step 13 image

14. Let's now search for Gold futures, using the root symbol of GC.  Let's select the first contract displayed, GCM21.

Step 14 image

15. Let's also add some currencies to the results.  Search USD and then select USD A U D.

Step 15 image

16. And let's search for Bitcoin using the BTC root symbol and select BTC USD and BTC E U R.  Then click Insert.

Step 16 image

17. Here's your custom quoteboard with Corn and Gold futures, as well as the US versus Australian Dollar pair and Bitcoin quoted in US dollars and Euro.

That's it for now, we hope you enjoy using Barchart for Excel!

Step 17 image