I need an excel formula to calculate the negative nominal rate of return given the negative effective rate and the number of compounding periods per year. Excel's NOMINAL and NPER functions do not work when a negative rate assumption is used resulting in a #NUM! error. The context for this is that I am using MS Excel to to investment analysis. I want to analyse the resulting value of an investment account balance when there is a negative effective rate and corresponding nominal rate of return (mimicing a declining value in a particular investment/account due to negative annual return on investment expressed as a negative annual effective rate of return but that is compounding monthly - and hence the need for the nominal rate and compounding periods). I need to use a calcualtion in Excel that gives me the negative nominal rate of return equivalent to the negative effective rate of return assumtion.
Please help and thank you in advance if you can solve this!
I want to calculate the survival rate/failure rate for a product. Usually I use weibull distribution (linear regression followed by the 'WEIBULL' function), but unfortunately the data I have simply won't work with my current methods.
I have 10 different groups of widgets.
Group 1 widgets were installed 1 year ago. A certain percentage of those widgets are failed.
Group 2 widgets were installed 2 years ago. A certain percentage of those widgets are failed.
...
Group 10 widgets were installed 10 years ago. A certain percentage of those widgets are failed.
There are far fewer 10-year widgets than 1-year widgets out there.
The catch is that I don't know if the group 1 widgets will survive year 2, or if year 2 widgets will survive year 3, etc.
I want to create a nice curve that tells me (approximately) how many years the average widget in my sample dies 50% of the time. Unfortunately, there doesn't seem to be any ready-made formula in Excel for this. So I turn to you, brave Excel Board Members, to help me save myself from Math.
Please?
Good day
I have a table called Budget Accounts. Its entry has a start date, an end date, and a total amount.
Assuming that today is between the start date and end date, I would like to have a query that divides the total amount by the number of days (or weeks or months, doesn't matter for now), and then adds up the amount from the start date to the end date.
I can sort of do this if every single item had the same amount, but of course they don't!
Any suggestions are appreciated!
Thank you
Kavy
Hi there! I need a formula to calculate the negative nominal rate of return given the negative effective rate and the number of compounding periods per year . Excel's NOMINAL and NPER functions do not work when a negative rate assumption is used resulting in a #NUM! error. The context for this is that I am using MS Excel to to investment analysis. I want to analyse the resulting value of an investment account balance when there is a negative effective rate and corresponding nominal rate of return (mimicing a declining value in a particular investment/account due to negative annual return on investment expressed as a negative annual effective rate of return but that is compounding monthly - and hence the need for the nominal rate and compounding periods). I need to use a calcualtion in Excel that gives me the negative nominal rate of return equivalent to the negative effective rate of return assumtion.
Please help and thank you in advance if you can solve this!
Hi,
I am using a MS query in my Excel file, which I can refresh in code with:
Worksheets("Cycles"). Range("B4").QueryTable.Refresh BackgroundQuery:=False
What I would like to do is as follows:
If the Query successfully refreshses, copy these values to another location.
Right now, the cells just reference the query cells, but this can cause errors if the Query does not successfully refresh (database is down, user doesn't have environmental parameters setup correctly, etc)
Thanks in advance.
Matt Lawson
Just wondering if anyone knew of a way to get a quicker refresh rate than the minimum of 1 minute in the web query options?
Regards
Jon
Can anyone tell me how to protect individual cells from being updated by a user BUT allowing the same cells to be updated by a database query.
Protecting a the sheet/cell does not allow this.
Thanks in advance
Hi,
I wondered if anyone knew how I can increase the Refresh rate on my Web Query to less than 1 minute?
When I go to the Refresh Control in the External Data Range Properties I have to enter a whole integer for the refresh rate, therefore 1 minute is the faster I can refresh my data automatically.
Is there a work around to increase the refresh rate?
Any help would be greatly appreciated.
Thank you.
I know how to get a complete quote by quering the web. But I just want the cell to have today's price. Can someone give me the code to get the price of IBM today, for example? I'd like to open the spreadsheet, hit Update, and have the cell show the current price. That should be simple but I can't figure it out. Thanks.
Chuck.
I have two columns, A and B
column A contains a date, and B contains a stock symbol. There are typically 75 or so symbols for each date, and i have a year worth of dates. i am looking for a way to use a web query to look up all of the stock prices on the corresponding dates. I have tried using web queries but those give me two problems.
The only sites I can get the data from gives me headers and other formatting... I only want the raw data.
Also, I cant figure out a way to "Fill" a webquery down a column.
Any insights on this would be greatly appreciated.
