aapl

Hey all! I am processing data downloaded from a Bloomberg terminal for over 8000 firms, but I am experiencing difficulty. The data set is in the current format: <tbody> AAPL BAC 1/1/2018 0.0430 -0.0131 1/2/2018 4.6958 0.1438 1/3/2018 0.8888 -0.1045 1/4/2018 1.0708 -0.4836 1/5/2018...

Can anyone help me with a VBA code that will take this list and create a summary list in column W-Y. Each item should have a subtotal like in the example in the next table. The Ticker and Name are in column A & B and the Amounts are in column P. The output should be place in in C. Greatly...

Hi, I am working on a assignment where I have to calculate the population and sample covariance matrix for stocks. I know there are easier ways, but we have to use these functions. I have my data in column form in another sheet and have named the data range after the ticker of the stock. I...

hi! i have two lists below, one is my inventory and one is what i want to match it against: inventory list <tbody> Ticker Quantity Counterparty AAPL 1 A AAPL 2 B BABA 1 A T 3 A T 4 A CIS 3 C NFLX 4 G NFLX 4 H NFLX 7 G </tbody> match to: <tbody> Ticker Quantity AAPL 3...

Hi All, Below is a macro I use to get real time price quotes from Google Finance. Each time I change the stock ticker in cell B3 and run the macro the query table appends the new ticker to the returned data. For instance, the first time I ran the macro with ticker AAPL, it put AAPL in E44 and...