# stocks

1. ### What version of Excel do I need to be able to use the STOCKHISTORY() function?

What version of Excel 365 do I need to be able to use the STOCKHISTORY() function? My software update attempt says Excel is up-to-date but I just wanted to verify.
2. ### Excel forms for Stocks- How to Track Dow Jones (DJIA) Patterns Like Up, Down, Up Up, Down Down

I uploaded the file here- https://file.io/Vr7mDPckVRSI PART 1 In the beginning, I need at least the formula to figure out UP down.... But then I need an idea of probability also. PART 2 I will consider (or you can consider) editing any columns or adding or deleting columns. The whole idea...
3. ### How to get a corresponding value based on the most recent date and name?

Hi, I'm making a stock investment tracker where all you have to do is enter in the transaction and it gives you all the your positions, whether they are open or closed etc. I was finally able to figure out a way to find my average cost per share after buying/selling/rebuying. I have a column...
4. ### Another Excel Formula For Stocks (Positive, Negative, Or Even)

Thanks for your help. Please post the formula in an equals formula, please with the exact cell numbers also. I am doing stock research and I wanted to find out how what the answer is (where I can drag the formula down) for rows T213 and T214. The way the formula works is like this \$53,376...
5. ### Excel Formula for Millions and Billions

Hello, Thanks for your help. I am looking to do a spreadsheet on stocks. On Yahoo Finance, the data copies over as M and B for Billions. Please check the attachment, and it shows these cells: Columns C thru I And Rows 360 thru 374 So, if you can please provide a formula for all of the green...
6. ### Data Cleaning and calculations

Hi, I have been trying to create a calculator which looks at returns from a stock if you average in over time (average in is when you put \$2000 into a stock every month or two months or so). Using data from yahoo finance such as...
7. ### Nested if

Hi Everyone, I need help about nested if. I have set of conditions that needs to be followed, unfortunately I dont know how to do it in Excel. Please help :( <tbody> WH Stocks Recommended Stocklogic Expected output 100 50 10 Recommended 100 110 50 Stocklogic 100 10 50 Stocklogic 0...
8. ### Excel Stocks not outputting some data

Hi, I am trying to create a spreadsheet that tracks stocks. When using the excel stocks function and outputting data, the market cap for all 500 stocks is coming up as ####### and I am also getting a #FIELD ! error for certain P/E or EPS data. I've attached a screenshot with issues highlighted...
9. ### How do I get the Stocks data type?

I don't see "Stocks" on the Data menu. I understand that the Stocks data type is only available to Office 365. I'm not 100% sure if I'm running Office 365 or not. I go to File --> Account --> About Excel, and it says "Microsoft Excel for Office 365 MSO (16.0.10730.20264) 32-bit". Is this not...
10. ### Solver for portfolio optimization issue

Hi there, I am trying to use Solver for portfolio optimization. I'm using 9 stocks and Solver runs fine when I try to optimize for the lowest monthly draw-down using all 9 stocks (it gives a weight to each stock from -1 to 1. Where I run into an issue is if I add a constraint that requires that...
11. ### Investment rebalancing every year for a basic stock/bond allocation

Hi guys, I've run into a mental roadblock trying to figure this out. I thought it was simple, but it was not as simple as I thought. In the table below, I can easily calculate the return of the portfolio and break it down into equity and fixed income allocation. However, through time, this...
12. ### Asset control register (booking assets inward/outward

All, Could any body help me? im struggling to overcome a problem :) please see the linked spreadsheer (you don't have to activate macros, they're just used for adding new rows - hopefully ill dev this into a userform interface) We have a 'required quantity' column which is the exact amount we...
13. ### Match Stock Prices with Stock Splits VBA

Greetings (first post and I am in need of help)! I am writing some VBA and here is what I would like to do but I am having difficulty creating the structure. I have a list of daily stock prices for multiple companies, although the stock prices do not indicate that they went through a stock...
14. ### Code Works, but only sometimes?

Hey all, for some reason my VBA code sometimes works, but sometimes spits out "Run-time error '1004': Application-defined or object-defined error". The section that causes trouble is always this one, specifically the select line: 'Entering Stocks from IB Report Dim Report As Workbook Set...
15. ### stock price period high formula

Hi all, first time poster here, I am trying to build a spreadsheet where I can have a list of stocks I am tracking and notify me when a stock makes a new 20 day and 55 day high. I want to link yahoo finance data or google finance data. I found a formula that others said this will work with...
16. ### Average Cost of stock from buy/sell transactions

I have stock buy/sell transactions and want to calculate my position. Here is some sample data: I can calculate most things I need but I'm struggling with Average Cost. So XXX bought 100 at \$1 then sold 50 at \$2, so my average cost is \$1. Then bought 100 at \$2 and sold 100 at \$3 so I have a...
17. ### DAX function for percentage change

HI, Imagine I want to create a formula that gives me the percentage change between to specific dates, and I want to do it within the powerpivot contexto (with DAX functions). For example:(just for the sake of the example, these numbers are false) A table with all the prices of Apple's stock...
18. ### An Excel Project

Hello, I am trying to do a project that is based in the analysis of stock quotes over several years. However I have a few questions and I hope you can help me. The project I want to analyze how certain stocks behave between specific dates, i.e, what is the percentage growth or decay between...
19. ### VBA to extract data based on first occurrence in column; Trading Analysis

Hi, I have an excel file with 1500 columns and each column has 4500 rows of data. Here is an example of what my spreadsheet looks like: https://imgur.com/a/n9mZ7 Here is what i'm looking to do. 1. I want excel to look at every 4th column starting from B. So the first column excel would...
20. ### BDH Formula in Macro VBA

Dear community, I would like to build a macro from directly obtaining Bloomberg Data (PX_LAST and OP_INT) for a large set of stock. Has anybody of you already tried to insert the BDH function into a Macro? How did you o it for multiple stocks? Could you create 1 table only? I am sorry fr this...

### This Week's Hot Topics

• separating multiple Proper names (uppercase letters) from a list
I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
• 'for' Loop
Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
• Open specific pdf in folder with vba
Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
• What is wrong with this For Loop code?
I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
• Data to match
Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
• Shifting Columns
Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back