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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

<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...

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...

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...

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...