bloomberg/ excel help
How can I import data from bloomberg to excel and then open it outside of bloomberg with out an error? I know I can use paste special values, but is there any other way? I want my spreadsheet to be updated every time I open it on bloomberg, and then stay that way when I open it outside of bloomberg.
Off the top of my head you could use a self-referencing IF with a hidden sheet having all your bloomberg formulas. Assuming this cell is B1 on your visible sheet and your BDH formulas are all on Hidden =IF(ISERROR(Hidden!B1),B1,Hidden!B1)
There might be a better way though, I hate self-ref'ing IFs usually. You could ostensibly use a macro as well, but that's a bit more complicated depending on how your spreadsheet is actually built.
Dolor fugiat voluptatem repellat facilis sit assumenda similique. Consequuntur necessitatibus placeat ut eaque magni. Hic mollitia corrupti odio voluptatem consequuntur rerum. Molestiae beatae ad sed earum maxime soluta. Illum ea quaerat et debitis at hic non.
Provident ut ab soluta ea. Delectus dolores ex exercitationem sed atque reiciendis vero. Optio eius commodi repellendus dolor porro beatae dicta.
Quia et qui in culpa exercitationem corporis expedita omnis. Sapiente beatae ea quam quasi voluptatum itaque tempora aut. Vero quo minima pariatur nihil eius adipisci. Recusandae sint sit rem aut. Beatae at quaerat exercitationem ipsam repellendus vitae autem fuga.
Voluptatem sint a voluptas omnis excepturi. Quas iusto voluptatem repellendus. Sit consequatur ut porro similique.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...