CQG News | Excel Sparklines

▤ Summary

Sparklines are a nice addition to a quote display as the quote display shows current values, such as last price and net change, the Sparkline chart can show price action. While any time frame can be used, for this article the Sparkline will display a 5-minute close chart for today’s session. To plot these Sparklines in Excel the CQG Barix (Bar Index) function is used within the RTD formula. For the close of each symbol on a 5-minite basis this RTD Formula is used: Notice above that if the value in column C is a “0” then the error NA() is returned (#N/A). Strongly recommended: Microsoft Office Professional Excel 2016, 2019, 32 or 64-bits installed on your computer, not in the Cloud.

▦ Linked Companies

CQG

$50M to $100M