securities

I'm trying to build a table that lists a broker's volume from largest to smallest (top 10 firms only). If there are only 9 values in the data set, a zero will appear in the row. To grab the volume, from largest to smallest, I'm using =LARGE($B$2:$B$63,1), =LARGE($B$2:$B$63,2)...

So in Column Z I have a credit rating for a bunch of securities (AAA,AA,A,BBB,BB,B etc) and in column AA I have sectors that the securities are in (Corporates, Government Related, Others). What I want to do is count up the number of say AAA securities that are in the Corporate sector. Any help...

I have a keen interest now in analyzing stocks and other forms of securities. I would like to be able to have Excel grab the information automatically and keep it up to date, but have been unsuccessful thus far. I understand this used to be possible from Yahoo Finance, but apparently they no...

Hello Forum. This is my first time posting so forgive me if I make any errors. First note, I have tried CTRL+SHFT+Enter and this did not solve my issue. Second not, I am using Excel Professional Plus 2010 A little back ground. I have built a spread sheet to use for building ETF and Mutual...

using =BDS(..."cols=6;rows=69") as my formula, I would like to pull just the number 69 and enter it into another cell. This number, 69, is automatically populated within the formula. To clarify, the number, 69, is not the resulting output in the cell... it's part of the formula. Also, this...