Search results

I have a series of transactions across various customer folios, in different mutual fund products, which are characterized by the fields [Folio_No] and [Prod_Code]. In the appended files, I have restricted the data to one Folio_No and Prod_Code, for simplicity. Transactions can either be buys...

In the attached ACCESS Db, I have a price table (NAV) with fields [Product Code], that indicates the product, [NAV Date] that indicates the price date, and [NAV] that indicates the price per unit for that product for that day. This table has a few gaps, largely because in many products (I have...

In the attached Access Database ("Cumulative Illustration"), I have a table FiFO_Temp_Live, which contains purchase transactions by folio (Field [Folio No]), product purchased (Field [Product Code]), Investor (Field [Mod PAN]) date (Field [TDate]), Purchase Amount (Field [Amount]), Price of...

I have two tables, PASTMONTH, which has all dates of the last month (in this case, July 2017) and ALLFUNDS_NAV, which has the net asset values (NAV) of two funds, since their inception. I have attached a database (Access 2013) with these two tables, and the query described below, for reference...

I currently have a query XIRR_Array, that returns three fields: Match Code (a concatenation of investor name and product code), CFlow, which is the cash flow (negative for outflow, positive for inflow) and TDate, which is the date of the cash flow. I have been trying to derive the XIRR for each...

I have a table “trxns_expt”, and a query “Max RDate” in the attached access database. Trxns_Expt contains a lot of fields of raw data pertaining to investments in various funds, of which only the following are relevant for this query: 1. Folio_no: the account number of the investor for that...

I have a transactions table which has transactions of various types done by different investors in various folios and products. I am interested in the transactions with have the [Mod Ttype] field set to "DR". I would like a date-wise listing of DR transactions for each [folio_no] and...

I have a table of Mutual Fund net asset values (NAVs) on a daily basis, called “Equity_Adj_NAV in my Access 2013 database. This table had the following fields: Code- Each Fund has a unique code NAV Date- The date on which the NAV is recorded NAV- the value of the fund on that day. A sample...