Skip to content

Instantly share code, notes, and snippets.

@mvberg
Created December 5, 2017 15:24
Show Gist options
  • Save mvberg/08f1e44694d5a8c5dfca06f040ae3586 to your computer and use it in GitHub Desktop.
Save mvberg/08f1e44694d5a8c5dfca06f040ae3586 to your computer and use it in GitHub Desktop.
Barchart RTD Example

Barchart RTD

As of this writing, there are 3 topics

  • Quote
  • Book
  • News

Examples

Quote

// Last Price for Apple
// note you can replace AAPL with a cell reference, eg $A1

 =RTD("barchart.rtd","", "Quote", "AAPL", "Last")  

Book

// BBO and size for ESZ17
// index is 0 based to 9 (higer is worst price)

=RTD("barchart.rtd","", "Book", "ESZ17", "asks", "0", "price")
=RTD("barchart.rtd","", "Book", "ESZ17", "asks", "0", "size")

// bid
=RTD("barchart.rtd","", "Book", "ESZ17", "bids", "0", "price")
=RTD("barchart.rtd","", "Book", "ESZ17", "bids", "0", "size")  

News

// Latest News Headline & Summary for AP

=RTD("barchart.rtd","", "News", "AP", "Headline", "0")
=RTD("barchart.rtd","", "News", "AP", "Summary", "0")
=RTD("barchart.rtd","", "News", "AP", "Time", "0")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment