The FactSet Request Builder

Introduction Using Request Builder Filtering ID search Multiple series and formulas Formulas in FactSet Limitations FactSet data examples in files Introduction Macrobond users that are enabled for the Macrobond FactSet Terminal Connector or Macrobond FactSet Direct can use the FactSet Request Builder to create the relevant calls to FactSet and integrate the required data directly … Continue reading “The FactSet Request Builder”

Data Explorer

Introduction Requirements How to log in? Working with Data Explorer Searching for data Configuring Time series panel Selecting series Information about series Visualizing Introduction Data Explorer is a online tool for feed users where you can look into and browse through our data-tree. Requirements You need to have a specific license. You cannot log in … Continue reading “Data Explorer”

Databricks feed

Introduction Data Discovery Set up your data feed in the Macrobond management panel Use your Snowflake data feed MAIN_ENTITY [Table] REVISION [Table] SUBSCRIPTION [View] LATEST_ENTITY [View] Introduction You can access any of Macrobond’s time series data into your Databricks environment. The data feed is intended for production purposes with near real-time updates. Here’s how it … Continue reading “Databricks feed”

Snowflake data feed

Introduction Data Discovery Set up your data feed in the Macrobond management panel Use your Snowflake data feed Data Dictionary MAIN_ENTITY [Table] REVISION [Table] SUBSCRIPTION [View] LATEST_ENTITY [View] Introduction You can access any of Macrobond’s time series data into your Snowflake environment. The data feed is intended for production purposes with near real-time updates. Here’s … Continue reading “Snowflake data feed”

Data Web API feed – How to update time series?

Introduction Universe Update (get_many_series) Universe Update with Revision History (get_many_series_with_revisions) Polling for updates (SubscriptionList) Poll for and Retrieve updates (GetDataPackageList) Introduction This document outlines several methods to update your universe of time series leveraging the Macrobond’s Python library. Please note, if you are using other languages than Python, or prefer to define your own functions, … Continue reading “Data Web API feed – How to update time series?”

The Macrobond FactSet Direct & Terminal Integration

Introduction 1.Macrobond FactSet Direct Requirements How to get access? 2.Macrobond FactSet Terminal Integration Requirements How to get access? Enabling FactSet integration (Direct & Terminal) Working with FactSet  FactSet Request Builder Series names FactSet Enhancement FactSet OFDB Revoking access Introduction Macrobond offers two ways to access FactSet data directly within the Macrobond platform: Macrobond FactSet Direct and … Continue reading “The Macrobond FactSet Direct & Terminal Integration”

The Macrobond Data API for Python (Python wrapper)

Introduction Requirements Installation Keyring Error: failed testing username and password Working with Python wrapper Download one series (Basic usage) Download one series (Advanced usage) Extensive guide – more examples Introduction The Macrobond Data API for Python uses either the Macrobond Web REST API or the Macrobond Client data API to obtain time series with values and metadata. The API … Continue reading “The Macrobond Data API for Python (Python wrapper)”

SQL In-house – connection strings

Introduction Macrobond SQL Database connector configuration file includes a section specifying data provider database connection string and connection string. It’s unique to each database type. This page includes examples for most commonly used databases. MySQL and MariaDB Please install https://dev.mysql.com/downloads/connector/net/ and use: <sql:DataProvider> <sql:Name>MySql.Data.MySqlClient</sql:Name> <sql:ConnectionString> Server=address.of.the.server; Database=dbname; Uid=user;Pwd=pass;​ </sql:ConnectionString> <!– instead of Uid=user;Pwd=pass;​ you can use … Continue reading “SQL In-house – connection strings”