load excel data created with bdh in excel. it can efficiently load hundreds of megabytes of excel data.
>> 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
引用格式
michael robbins (2023). load large bloomberg excel data file (https://www.mathworks.com/matlabcentral/fileexchange/130729-load-large-bloomberg-excel-data-file), matlab central file exchange. 检索来源 .
matlab 版本兼容性
创建方式
r2023a
兼容任何版本
平台兼容性
windows macos linux标签
community treasure hunt
find the treasures in matlab central and discover how the community can help you!
start hunting!探索实时编辑器
创建集代码、输出和格式化文本于一体的可执行脚本文档。
| 版本 | 已发布 | 发行说明 | |
|---|---|---|---|
| 1.0.0 |
|