Requires the shared Bloomberg Terminal Username which is provided on the monitor, or your own.

Our ability to provide a DBaaS (DataBase as a Service) platform is critical to our clients ability to retrieve and analyze. Bloomberg terminal at the Eddie Davies Library: Come in person to the Finance Zone for regular Bloomberg database use or the Bloomberg API and Excel add-in functionality Up to 7 concurrent users. Our team is designing the next generation systems for managing this piece of crucial infrastructure. Bloombergs software solutions depend on robust data infrastructure to provide clients with this data. Use the Field Search tool in Excel to search by category or keyword. Our Team: Bloomberg is the industry standard for financial data. When using any of the formulas, you must specify the security for which you want to retrieve data (Security), and you must specify the data item you want to retrieve (Field). The Security must be represented as (Ticker) (Market Sector), for example TGT Equity.įields are represented by mnemonics.

BDS (Bloomberg Data Set) is for large data sets/ bulk data.

BDH (Bloomberg Data History) is for historical end of day and historical intraday data.

BDP (Bloomberg Data Point) is for current data.

In the Excel Add-in, Bloomberg functions are consolidated with flexible optional parameters: Bloomberg has data on over 200,00 quantified supply chains.

By loading an equity in Bloomberg and then running the SPLC function, all the company’s suppliers and customers will display. A Bloomberg terminal allows direct access to Bloombergs data service which includes real-time financial data, analyst estimates, messaging, and trading.

Select the type of data you want download, then follow the steps.īloomberg’s worksheet functions provide intermediate to advanced Excel users flexibility to construct their own formulas to customize the way Bloomberg data is delivered and organized in the spreadsheet. SPLC is the most important function for performing supply chain research on the Bloomberg terminal. You can launch the Import Data wizard by, selecting Spreadsheet Builder from the Bloomberg Menu or by clicking on the Import Data icon on Excel toolbar. Spreadsheet Builder makes it easy to import Bloomberg data into a spreadsheet by automatically generating the appropriate functions through an easy step-by-step process.

Bloomberg terminal database