{"id":59392,"date":"2022-05-03T15:23:28","date_gmt":"2022-05-03T19:23:28","guid":{"rendered":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/"},"modified":"2023-05-09T00:33:11","modified_gmt":"2023-05-09T04:33:11","slug":"charts-of-the-week-9th-may-2022","status":"publish","type":"webinar","link":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/","title":{"rendered":"Charts of the Week: TSIG in Excel via BQL"},"featured_media":0,"template":"","webinar_cats":[2943],"series":[],"language":[2972],"availability":[2995],"web_categories":[],"class_list":["post-59392","webinar","type-webinar","status-publish","hentry","webinars-charts-of-the-week","language-english","availability-ondemand"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.11 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Charts of the Week: TSIG in Excel via BQL Webinars | Bloomberg Professional Services<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Charts of the Week: TSIG in Excel via BQL Webinars | Bloomberg Professional Services\" \/>\n<meta property=\"og:description\" content=\"This week&#8217;s webinar looks at how we can utilize Bloomberg Query Language (BQL) in order to recreate portions of TSIG and build on top of it through Excel and will cover the following:\u00a0 Review TSIG function Pull underlying data via BQL Filter for trading signals Aggregate trading signals on a universe\" \/>\n<meta property=\"og:url\" content=\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/\" \/>\n<meta property=\"og:site_name\" content=\"Bloomberg Professional Services\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/bloomberglp\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-09T04:33:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/assets.bbhub.io\/image\/v1\/resize?width=auto&type=webp&url=https:\/\/assets.bbhub.io\/professional\/sites\/41\/BPS-og-image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@theterminal\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/\",\"url\":\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/\",\"name\":\"Charts of the Week: TSIG in Excel via BQL Webinars | Bloomberg Professional Services\",\"isPartOf\":{\"@id\":\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#website\"},\"datePublished\":\"2022-05-03T19:23:28+00:00\",\"dateModified\":\"2023-05-09T04:33:11+00:00\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#website\",\"url\":\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/\",\"name\":\"Bloomberg Professional Services\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#organization\",\"name\":\"Bloomberg Professional Services\",\"url\":\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/assets.bbhub.io\/image\/v1\/convert?type=auto&amp;url=https%3A%2F%2Fassets.bbhub.io%2Fprofessional%2Fsites%2F41%2Flogo.png\",\"contentUrl\":\"https:\/\/assets.bbhub.io\/image\/v1\/convert?type=auto&amp;url=https%3A%2F%2Fassets.bbhub.io%2Fprofessional%2Fsites%2F41%2Flogo.png\",\"width\":\"512\",\"height\":\"103\",\"caption\":\"Bloomberg Professional Services\"},\"image\":{\"@id\":\"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.instagram.com\/bloomberg\/\",\"https:\/\/www.linkedin.com\/showcase\/bloomberg-professional-service\/\",\"https:\/\/www.facebook.com\/bloomberglp\",\"https:\/\/twitter.com\/theterminal\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Charts of the Week: TSIG in Excel via BQL Webinars | Bloomberg Professional Services","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/","og_locale":"en_US","og_type":"article","og_title":"Charts of the Week: TSIG in Excel via BQL Webinars | Bloomberg Professional Services","og_description":"This week&#8217;s webinar looks at how we can utilize Bloomberg Query Language (BQL) in order to recreate portions of TSIG and build on top of it through Excel and will cover the following:\u00a0 Review TSIG function Pull underlying data via BQL Filter for trading signals Aggregate trading signals on a universe","og_url":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/","og_site_name":"Bloomberg Professional Services","article_publisher":"https:\/\/www.facebook.com\/bloomberglp","article_modified_time":"2023-05-09T04:33:11+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/assets.bbhub.io\/image\/v1\/resize?width=auto&type=webp&url=https:\/\/assets.bbhub.io\/professional\/sites\/41\/BPS-og-image.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@theterminal","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/","url":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/","name":"Charts of the Week: TSIG in Excel via BQL Webinars | Bloomberg Professional Services","isPartOf":{"@id":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#website"},"datePublished":"2022-05-03T19:23:28+00:00","dateModified":"2023-05-09T04:33:11+00:00","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/insights\/webinar\/charts-of-the-week-9th-may-2022\/"]}]},{"@type":"WebSite","@id":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#website","url":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/","name":"Bloomberg Professional Services","description":"","publisher":{"@id":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#organization","name":"Bloomberg Professional Services","url":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#\/schema\/logo\/image\/","url":"https:\/\/assets.bbhub.io\/image\/v1\/convert?type=auto&amp;url=https%3A%2F%2Fassets.bbhub.io%2Fprofessional%2Fsites%2F41%2Flogo.png","contentUrl":"https:\/\/assets.bbhub.io\/image\/v1\/convert?type=auto&amp;url=https%3A%2F%2Fassets.bbhub.io%2Fprofessional%2Fsites%2F41%2Flogo.png","width":"512","height":"103","caption":"Bloomberg Professional Services"},"image":{"@id":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.instagram.com\/bloomberg\/","https:\/\/www.linkedin.com\/showcase\/bloomberg-professional-service\/","https:\/\/www.facebook.com\/bloomberglp","https:\/\/twitter.com\/theterminal"]}]}},"_links":{"self":[{"href":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/wp-json\/wp\/v2\/webinar\/59392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/wp-json\/wp\/v2\/webinar"}],"about":[{"href":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/wp-json\/wp\/v2\/types\/webinar"}],"version-history":[{"count":0,"href":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/wp-json\/wp\/v2\/webinar\/59392\/revisions"}],"wp:attachment":[{"href":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/wp-json\/wp\/v2\/media?parent=59392"}],"wp:term":[{"taxonomy":"webinars","embeddable":true,"href":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/wp-json\/wp\/v2\/webinar_cats?post=59392"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/wp-json\/wp\/v2\/series?post=59392"},{"taxonomy":"language","embeddable":true,"href":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/wp-json\/wp\/v2\/language?post=59392"},{"taxonomy":"availability","embeddable":true,"href":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/wp-json\/wp\/v2\/availability?post=59392"},{"taxonomy":"web_category","embeddable":true,"href":"https:\/\/professional.content.cirrus.bloomberg.com\/professional2023\/wp-json\/wp\/v2\/web_categories?post=59392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}