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. |
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. |
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. |
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. |
5. Here are the different time periods you can choose from. Select 1-Month then click Insert. |
6. And here is the Performance Leaders table for Futures. You will see both Bullish and Bearish trends are provided. |
7. Next let's take a look at the market data available within the Currencies section. Click the Currencies icon. |
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. |
9. Here is the Popular Cross rates table, instantly displayed in Barchart for Excel.  |
10. Market data for cryptocurrencies is also available within Barchart for Excel. Let's select Popular Coins and then click Insert. |
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. |
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. |
13. Let's search for Corn and then double click the ZCN21 symbol for July 2021 Corn Futures. |
14. Let's now search for Gold futures, using the root symbol of GC. Let's select the first contract displayed, GCM21. |
15. Let's also add some currencies to the results. Search USD and then select USD A U D. |
16. And let's search for Bitcoin using the BTC root symbol and select BTC USD and BTC E U R. Then click Insert. |
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! |