Q. What are the restrictions on downloading data from Bloomberg?
-
Browse:
- All
-
Topics
- 40Academic Liaison
- 3Accessibility
- 2Advertising
- 3Assistive Technology Room
- 1Bikes
- 3Book recommendation
- 12Books
- 10Borrowing, returning and renewals
- 2Building maintenance
- 34Cafe/Catering
- 3Cleaning
- 4Collections
- 1Communications team
- 5Complaint
- 49Compliment
- 4Copyright
- 10Customer service
- 3DVD collection
- 45E-Resources
- 3Economics & Finance
- 1Exams
- 5Finding resources
- 1Fines
- 10Food & Drink
- 18Furniture
- 6Group Study Rooms
- 2Hand-dryers
- 14Heating
- 9Helpdesk
- 1Holds
- 1ID Card
- 11Inter-library loans
- 14IT
- 5Journals
- 1King James Library
- 3Library Account
- 2Library Collections
- 23Library environment
- 9Library equipment
- 27Library Facilities
- 3Library Search
- 10Library staff
- 1Lighting
- 1Lockers
- 98Main Library
- 2Management
- 25Martyrs
- 6Membership
- 3More Books
- 9Newspapers
- 14Noise
- 3Off-campus access
- 1Open Access
- 13Opening hours
- 1Parking ticket
- 1Password
- 1Photographic Collection
- 5Power sockets
- 3Pure
- 14Reading lists
- 1Recall
- 7Recycling
- 7Referencing
- 16Referencing software
- 3Research Information System
- 9Scan
- 4Searching
- 1Semester 2 2021-22
- 1Short loan
- 6Signage
- 8Smoking
- 1Special Collections
- 6St Mary's Library
- 6Stationery
- 26Study space availability
- 3Temperature
- 2Theses
- 19Toilets
- 1Using other libraries
- 4Vacation
- 6Vending machines
Answered By: Hilda McNae Last Updated: Apr 04, 2024 Views: 30
Answered By: Hilda McNae
Last Updated: Apr 04, 2024 Views: 30
Data extracted through Excel API is subject to download limits which once reached will prevent further downloads. This is strictly enforced by Bloomberg and will not reset until the start of the following month
Try the following methods to avoid reaching the download limit and to ensure you have only the securities or fields you need.
- Use the Bloomberg terminal rather than Excel wherever possible
- Use the Worksheet function W<GO> which is like a spreadsheet but doesn't have a download limit
- Use the advanced screening capabilities within Bloomberg to make sure you have the final data you need. Find this option by using EQS for equities and other securities and then choose Screening Criteria.
- Bloomberg Query Language can help with data consumption, This lets you screen, aggregate, and run statistical analysis on a large list with a single query
- Once you have the data you need, copy it then paste-as-values or save as CSV so you don't download the same thing more than once
- Use <HELP> to find out more about the functions listed above.
The following error messages indicate that downloading is disabled
- #N/A Authorization
- #N/A Limit
- #N/A Mth Lmt
- #N/A Unknown
Was this helpful? 0 0
Comments (0)
Related Topics
Chat with us
© 2024 The University of St Andrews is a charity registered in Scotland, No: SC013532