finansu
finansu copied to clipboard
brymck
[No longer actively maintained.] Financial tools for Excel
you have to convert dates into text using the =text() command for the YahooHistory() command, otherwise it reads the date field as a number.
Using the GetYahooQuote and GetGoogleQuote functions cause the processor to "recalculate" every 3 seconds. It makes it unusable on any sort of scale and ties up excel.
Hi, I am trying to import live quotes for option prices. I do not want calculated prices. I want to get live last traded prices. Any ideas? Thanks. Dave
I have put this on several computers all excel 2010 or prior, and have used for a few years now, but we recently got Excel 2013 and I can not...
Hi, I am getting #value error , every time i try to pull the history quotes for BSE/NSE, be it from Bloomberg or Google. for example:Mothersumi(NSE) and BOM:517334(BSE) is the...
By using live quotes there is a memory leakage in Excel 2010. The memory Excel consumes, grows bigger and bigger until (eventually), Excel begins to behave erratically and does not...
I noted that when using the com add-inn for Finansu (32 bit version, installed on Excel 2010 (32 bits) it does 2 things: - It slows the computer down and...
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...
I am using FinAnSu to pull data from Bloomberg.com. Everything works fine except for the date and time fields, which remain blank. I have tried a variety of ticker symbols,...