fund

  1. J

    Retrieve live data from index fund

    Hi there. I own shares in a Canadian index fund. Fund code is RBF556. Canadian index fund. I was just wondering if there is a way to retrieve the quote automatically from the web when the spreadsheet is open. Thank you.
  2. A

    Limitation on rules in power query

    Hai, Can i know that how many number of rules maximum in power query? I have some rules in power query as below, the problem the query not functioning if i add few more query to this. Really need your help and how to increase numbers rules or any other alternative. Thank you in advance...
  3. V

    Index/Match & Offset Problem

    Hi, below I created a simplified version of two worksheets I have. I'm trying to create a formula in Sheet2 that will find the 1st instance of the fund# in Sheet1 B:B, get the value to the left of it in A:A, offset that cell by the amount of rows between that cell and the 1st instance of...
  4. M

    [VBA] Data from Morningstar website to excel

    Hi, Im very new to VBA and I'm trying to run a script which I found on this forum from 2012 posted by "Beeferino". I made 2 changes, the first being the URL as I don't think the original link works anymore and secondly I changed the word from InternetExplorer -> MicrosoftEdge, which I hope will...
  5. D

    Averageifs on Duplicate Columns

    I have been searching around the boards without any luck. I am trying to find an average of a series of values based on column headers F4:EU4 where the rows names in A5:A37 are unique. I have tried =averageifs(index($F$5:$EU$37,,match("Mutual Fund Name",$A5:$A37)),$F$4:$EU$4,"Peer Group...
  6. S

    Horizontal sum with multiple criteria

    I've been driving myself crazy this morning trying to make this work, but I know someone here can point me in the right direction. I have some premiums collected sorted by month received on the horizontal axis and three breakdowns for the premium in column D. I would like to sum these for each...
  7. S

    If Thens

    I know this is probably easy, but I haven't been able to make it work. This is what I'm trying to do: If Cell M2 contains a certain string of Characters, I want it to return "Fund" if it does, and "Ad Hoc" if it doesn't. I've got it to where it will return Ad Hoc for everything but can't get...
  8. P

    Automating Solver, long data structure

    Hi everyone, i have a dataset containing funds, their monthly returns and cashflows. It's a long data structure, so i have multiple rows for each fund. Then i have to solve an Equation with solver for each fund. I want to calculate an internal rate of return using the formla...
  9. M

    Power Query Filter And versus Or

    When using filters on columns I was taught it's better to use the text filters than unchecking items. So my rule of thumb has always been to use "or" versus "and" because AND means both criteria have to be met to exclude the row OK so today I have a list of fund numbers (coded as text) 1, 2...
  10. S

    vba messagebox return a string of data associated with other column Cells

    Hi, Trying to amend the code to include in the message box details of failed items. So in the active column, I have some cells indicating "FAILED". in the adjacent columns I have data in Column A and B. How will the below code be amended so it lists the corresponding data in Column A and B...
  11. P

    Turn duplicate rows into unique VBA

    Hi all, i would like to turn duplicate rows into unique using VBA. Therefore the data start from "A2" and the code should run through col. "A" and where the rows are duplicates, should place a number (serial number) on left of description. below i present the original data and the expected...
  12. S

    XIRR with non-contiguous last value

    I have been wrestling with a XIRR formula for the past week. I have a table with outflows and fund names for each outflow. I created a XIRR formula that not only takes into a count a specific fund identified in cell F2 but also prevents any XIRR errors when the initial outflow value is 0. The...
  13. S

    Mouse hover/rollover dispaying data from different cell

    Hi there and thanks for your taking the time to read this. Is it possible to hover over a cell and display the value from a different cell. I have a retirement fund sheet. m7 is the fund value at the beginning of the year m21 is the current value m22 is percentage up or down for the year m23...
  14. M

    Help with something more advanced than VLOOKUP

    I would like to create a worksheet that includes pulls data for each fund, but one fund (i.e. AA Fund) at a time and for Net Purchases for fund total ($6,678.00 as of Oct 1, 2018). I would like to create a table that shows the time series. For example, column A should be the date, 10/01/2018...
  15. C

    Transpose from Rows to Columns

    I have a Database of Mutual Fund Navs... It has 4 columns Scheme Code : It is a 6 digit string Scheme Name : String Net Asset : Numeral with 2 decimal place Value Date : Date I import the data from a Webpage to Excel and Formatted as above. The size of the data will increase depending on...
  16. D

    Text file to excel back to text file

    So I have a massive text file I receive each month that I need to make edits to and then load to a database. I would love to be able to convert this text file into excel and make my edits there (save hours of time) and then convert it back to a text file. I can open the text file fine with...
  17. S

    VBA- how to dynamically extract a list of values from a column range given a condition

    <tbody> A B C D E F FUND CODE FUND CODE DEALER CODE DEALER CODE DEALER CODE AAA ABA 123 345 678 BBB BAB 987 654 321 CCC C123 111 222 333 </tbody> Above table is in "Fundata List" Tab: <tbody> Hi, I would like to write a macro that will extract all the dealer codes from a tab...
  18. M

    Index Function Help!

    Greetings, I have a worksheet with monthly returns for numerous mutual funds, however not all of the funds have the same start date. Example: <tbody> 1 2 3 4 Fund A Fund B Fund C 1/31/2000 2.96 NA NA 2/28/2000 2.64 -2.3 NA 3/31/2000 .36 -1.4 NA 4/30/2000 -3.24...
  19. R

    best way to link cells from other worksheets/workbooks

    Hi, I'm new to this forum, so I am glad I found you all and hope you can help. I have a workbook where I record monthly stock data. this data is linked to other worksheets and some other workbooks where I have formula's to do various calculations. The way I link them is using the "=" and...
  20. C

    Need help with formula involving lookups, indexes, matches -- not sure how to accomplish this

    I'm sorry that I'm posting this in a rush so this may not be the best way to illustrate my problem - but here's an idea of what I want and how I'm getting it now: <tbody> A B C D E F G H I J 1 Fund Value Large Stock Mid Stock Small Stock Intl Stock ST Bonds Mid Bonds LT...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top