Load Large Bloomberg Excel Data File

Versión 1.0.0 (57,5 KB) por Michael Robbins
Load Excel data created with BDH in Excel. It can efficiently load hundreds of megabytes of Excel data.
0.0
(0)
9 Descargas
Actualizado 7 jun 2023

Ver licencia

Load Excel data created with BDH in Excel. It can efficiently load hundreds of megabytes of Excel data.
www.QuantitativeAssetManagement.com
https://www.amazon.com/Quantitative-Asset-Management-Michael-Robbins/dp/1264258445/
>> tBBG = LoadLargeBloombergExcelDataFile('BBGHistory.xlsx',4,4,10)
tBBG =
22×2 timetable
Date AAPL US Equity IBM US Equity
___________ ______________ _____________
08-May-2023 173.5 123.4
09-May-2023 171.77 122.83
10-May-2023 173.56 123.69
11-May-2023 173.75 122.56
12-May-2023 172.81 124.52
15-May-2023 172.31 125.05
16-May-2023 172.31 125.15
17-May-2023 172.93 127.43
18-May-2023 175.29 127.88
19-May-2023 175.4 129
22-May-2023 174.44 129.25
23-May-2023 171.8 129.94
24-May-2023 172.08 127.4
25-May-2023 173.23 128.5
26-May-2023 175.67 130.66
30-May-2023 177.55 131.25
31-May-2023 177.5 130.35
01-Jun-2023 180.34 131.6
02-Jun-2023 181.2 134.23
05-Jun-2023 179.83 134.46
06-Jun-2023 179.46 134.51
07-Jun-2023 180.42 134.32

Citar como

Michael Robbins (2024). Load Large Bloomberg Excel Data File (https://www.mathworks.com/matlabcentral/fileexchange/130729-load-large-bloomberg-excel-data-file), MATLAB Central File Exchange. Recuperado .

Compatibilidad con la versión de MATLAB
Se creó con R2023a
Compatible con cualquier versión
Compatibilidad con las plataformas
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Versión Publicado Notas de la versión
1.0.0