brymck / finansu

[No longer actively maintained.] Financial tools for Excel
MIT License
97 stars 42 forks source link

Errors after leaving spreadsheet open for 12 hours #13

Open jman11 opened 12 years ago

jman11 commented 12 years ago

I have a spreadsheet that uses finansu to pull about 50 quotes from Bloomberg. I use the Quote() function with the following parameters: p%hlovdt. I use this function in multiple tabs.

I left the spreadsheet open over night for about 12 hours. When I woke up this morning, I saw the a .Net error had been thrown (error log a). I closed this, added a new symbol to the bottom of an existing list of symbols, and then did a drag-drop of the Quote() function in the previous row. I then received another error (error log b) followed by a third error (error log c). The spreadsheet still seems to function, but it isn't clear if the function is still polling Bloomberg.

I am not sure how to post attachments, but let me know and I can post the three errors.