Home > Forum Home > Valuing Investments and Businesses > Work with Excel and Bloomberg > Work with Excel & Bloomberg Share

Work with Excel & Bloomberg

Excel Help for Work With Excel & Bloomberg in Valuing Investments and Businesses

Forum TopicLogin

Work With Excel & Bloomberg

Rate this:
(4/5 from 2 votes)

Thanks for your reply. I've already started my development using BB's ActivieX control for VBA and for now I should do my development on BB installed/licensed machine. Then only I can download data from BB. Is this an only way to develop an application using the BB API?

Can I use the following code to contact BB from a non-BB licensed (my development) machine?

VBA Code:
ChNo = Application.DDEInitiate(app:="BLP", topic:="S")

BBQuery = " ' " & ISIN & Corp & ", [RTG_SP] ' "

BBList = Application.DDERequest(ChNo, BBQuery)

Thank you once again and looking forward to your reply.
 Posted by on
View Full Post

Excel templates and solutions matched for Work with Excel & Bloomberg:

Solutions: OLAP Reporting Resource Management Construction Cost Estimation Employee Shift Scheduling Complete Trading System Financial VBA Code Password Recovery Business Planning Templates Index Numbering and Logging Real Time Stock Quotes Charting Tools Compare Files Worksheet Analysis Separate Data Video Tutorials Dimensional Analysis and Measurement Construction Schedule Templates Workbook Search File Navigator Merge Data Ranges Batch Printing Training Templates Six Sigma Templates Random Sampling Dashboard Training with Examples Work Efficiency Add-ins
Categories: Excel Productivity Time Saving