Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel Formula Query

  • 10-01-2020 04:23PM
    #1
    el Fenomeno
    Registered Users, Registered Users 2 Posts: 3,912 ✭✭✭


    I think its a case of tough luck, but I'll ask anyway in case anyone knows a way..

    I have Bloomberg add in on Excel. That is, I can use formulae that link back to Bloomberg and pull live data using security identifiers. It refreshes live, that is when Bloomberg update their price, the prices on my spreadsheet update in real time (I don't have to refresh).

    I saved this file a couple of days ago. Is it possible to see what those values / results were at the time I saved it? I open it now and I see the live prices.

    Thanks


Comments

  • #2
    raxy
    Registered Users, Registered Users 2 Posts: 905 ✭✭✭raxy


    Try opening it when the computer isn't connected to the internet. Shouldn't be able to update then so I would imagine the formulas would show the last saved value.


  • #3
    el Fenomeno
    Registered Users, Registered Users 2 Posts: 3,912 ✭✭✭el Fenomeno


    raxy wrote: »
    Try opening it when the computer isn't connected to the internet. Shouldn't be able to update then so I would imagine the formulas would show the last saved value.

    I'll try, but I'm fairly certainly I'll just get an #N/A Connection Unavailable result like what happens if I haven't logged into Bloomberg Terminal on the same computer.

    Anyway, I've been on to Bloomberg who've been able to give me a formula I never could have come up with myself that will do the trick so I wasn't completely out of luck.


Advertisement