{"id":6099,"date":"2021-03-16T08:17:42","date_gmt":"2021-03-16T16:17:42","guid":{"rendered":"https:\/\/officedevblogs.wpengine.com\/?p=6099"},"modified":"2021-03-16T08:17:42","modified_gmt":"2021-03-16T16:17:42","slug":"factset-for-excel-leverages-the-equivalentaddin-element-for-com-add-in-compatibility","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/factset-for-excel-leverages-the-equivalentaddin-element-for-com-add-in-compatibility\/","title":{"rendered":"FactSet for Excel leverages the EquivalentAddin element for COM add-in compatibility"},"content":{"rendered":"

\"Blog<\/p>\n

Scott St. Germain, Principal Software Engineer, FactSet<\/p>\n

Mike McElligott, Senior Product Manager, FactSet<\/p>\n

FactSet delivers flexible, open data and software solutions which help investment professionals see and seize opportunity sooner. The FactSet for Excel add-in<\/a> enables users to bolster their Excel models and workbooks with dynamic, refreshable FactSet content including financials, estimates, prices, ownership, credit analysis, and more.<\/p>\n

The Early Access version of the FactSet Office Add-in allows you to:<\/p>\n

Create =FDS<\/strong> FactSet formulas<\/p>\n

Refresh both new and existing =FDS<\/strong> FactSet formulas<\/p>\n

\"\"
Source:\u202fFactSet\u202ffinancial data and analytics.<\/figcaption><\/figure><\/p>\n

Why we build on the Office Add-ins platform<\/h3>\n

With the digital transformation across the finance industry, we found that relying on just a Windows desktop solution wasn\u2019t a solution for all our customers. However, we found developing on the Office Add-ins platform enabled us to provide a uniform Excel experience for both our Mac and PC-based clients. The release of FactSet for Excel compliments our existing web-based platform, meaning our users can access our tools and analytics on multiple platforms easily.<\/p>\n

EquivalentAddin element for Web\/PC compatibility<\/h3>\n

Our previous FactSet COM add-in has a large base of users who incorporate FactSet data into their spreadsheets using our User-Defined Functions (UDFs) in Excel.\u202fWe wanted to extend the FactSet data to new platforms, while maintaining compatibility with our COM add-in for the many people who rely on it.<\/p>\n

The EquivalentAddins element<\/a> in the Excel manifest file allows custom functions implemented on the Office JavaScript platform to be compatible with UDFs in legacy Excel automation. The following JavaScript code shows how few steps this compatibility requires. In this example, the FactSet COM add-in “FactSet.OurOfficeComAddin.1” is loaded if it already is installed on a user\u2019s computer. If this COM add-in has not been previously installed, the user will instead use our current offering.<\/p>\n

<EquivalentAddins>\n  <EquivalentAddin>\n    <ProgId>FactSet.OurOfficeComAddin.1<\/ProgId>\n    <Type>COM<\/Type>\n  <\/EquivalentAddin>\n    <FileName>factset-automation.xll<\/FileName>\n    <Type>XLL<\/Type>\n<\/EquivalentAddins><\/pre>\n
Using this mechanism for interoperability means that our clients enjoy a seamless experience with FactSet formulas in their spreadsheets across both automation platforms \u2014 traditional Excel automation as well as web-based automation with Office add-ins.<\/p>\n
Learn more about EquivalentAddins in the Office Add-ins documentation<\/a>.<\/p>\n
For more information about FactSet, visit www.factset.com.<\/p>\n","protected":false},"excerpt":{"rendered":"
FactSet delivers flexible, open data and software solutions which help investment professionals see and seize opportunity sooner. The FactSet for Excel add-in enables users to bolster their Excel models and workbooks with dynamic, refreshable FactSet content including financials, estimates, prices, ownership, credit analysis, and more.<\/p>\n","protected":false},"author":69076,"featured_media":25159,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[11],"tags":[18],"class_list":["post-6099","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-add-ins","tag-excel"],"acf":[],"blog_post_summary":"
FactSet delivers flexible, open data and software solutions which help investment professionals see and seize opportunity sooner. The FactSet for Excel add-in enables users to bolster their Excel models and workbooks with dynamic, refreshable FactSet content including financials, estimates, prices, ownership, credit analysis, and more.<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/6099","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/users\/69076"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/comments?post=6099"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/6099\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/media\/25159"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/media?parent=6099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/categories?post=6099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/tags?post=6099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}