jagomart
digital resources
picture1_Excel Sheet Download 7306 | Mfqsbatchupload Csv - Standar Format


 215x       Filetype XLSX       File size 0.03 MB       Source: www.nasdaqtrader.com


File: Excel Sheet Download 7306 | Mfqsbatchupload Csv - Standar Format
sheet 1 mfu this worksheet reflects the mfqs valuation message format for most mfqs asset classes firms may use this document as a guide to create csv files header row ...

icon picture XLSX Filetype Excel XLSX | Posted on 27 Jun 2022 | 3 years ago
Partial file snippet.
Sheet 1: MFU
This worksheet reflects the MFQS valuation message format for most MFQS asset classes. Firms may use this document as a guide to create CSV files. Header row must be left as is. Instruction / sample rows, however, need to be removed from document before converting to CSV file format. Please note that Nasdaq requires that firms use one of the following naming standards for CSV valuation files: MPID_MFQSVersion_MessageType_UploadDate.csv MPID_MFQSVersion_MessageType_ UploadDate _FileTime.csv Please note that the current MFQSVersion is 0050. MessageType FundID Footnotes FundType ReportingType NAV NAVOverride OfferMarketPrice OfferMarketPriceOverride NAVRedemption NAVRedemptionOverride WrapPrice Assets AssetsOverride YieldCurrent ELTR AccruedInterest DividendDaily DividendDailyAdjustment EntryDate Currency CUSIP
Enter "MFU" for MFQS valuation records for the following asset classes:

Mutual Funds
Unit Investment Trusts (UITs)
NextShares Exchange Traded Managed Funds
Annuities
Structured Products
Alternative Investment Products (AIPs)
Enter MFQS Symbol for payload record

MFQS Instrument record (and MFQS Directory download file) shows the current symbol / fund ID
Enter MFQS footnote code(s) to denote special price calculation situations

Standard fund level codes include:
H = Deferred Sales Charge
N = No Load Fund
F = T+1 Data Used For Calculations
P = 12(b)1 fees
O = Primary Offering for UITs
Y = Secondary Offering for UITs

Standard market driven codes include:
D = Capital Distribution
S = Stock Dividend
X = Cash Dividend / Interest

See file upload specifications for full footnote code list
Enter MFQS Instrument Type for payload record

MF = Mutual Fund
UT = Unit Investment Trust (UIT)
EM = NextShares Exchange Traded Managed Fund
AN = Annuity
SP = Structured Product (SP)
AP = Alternative Investment Product (AIP)
Enter MFQS reporting frequency code

R = Regular / Daily Calculation
I = Intraday Calculation

Note: For mutual funds and other asset classes, vendors will display the MFQS system processing time on intraday updates
Enter numeric value or "NA"

NAV is required field for mutual funds, NextShares, annuities, SPs, and AIPs

Enter NAV in standard number format for these asset classes

Field is processed in currency units so 1 = $1

Minimum value = 0.000001
Maximum value = 999999.999999

Redemption NAV is required for UITs (which should populate field as "NA")
Leave field blank for standard MFQS price validation logic

Standard validation logic compares NAV in file to prior NAV in MFQS system; rejects if difference is more than defined %

Enter # to override MFQS price parameter validation logic
Enter numeric value or "NA"

Enter Offer / Market Price in standard numeric format

Field is processed in currency units so 1 = $1

Minimum value = 0.000001

Maximum value = 999999.999999

Leave field blank for standard MFQS price validation logic

Standard validation logic compares Offer / Market Price in file to prior Offer / Market Price in MFQS system; rejects if difference is more than defined %

Enter # to override MFQS price parameter validation logic
Enter numeric value or "NA"

Redemption NAV is required for UITs

Enter NAV in standard number format for this asset class

Field is processed in currency units so 1 = $1

Minimum value = 0.000001
Maximum value = 999999.999999

Other asset classes should populate field as "NA"
Leave field blank for standard MFQS price validation logic

Standard validation logic compares Redemption NAV in file to prior Redemption NAV in MFQS system; rejects if difference is more than defined %

Enter # to override MFQS price parameter validation logic
Enter numeric value or "NA"

Wrap price is typically entered for UITs

Field is processed in currency units so 1 = $1

Minimum value = 0.000001
Maximum value = 999999.999999

If not populated, MFQS system will process field as not available and send "NA" to downstream users
Enter Total Net Assets value as numeric value or "NA"

Field is processed in standard currency units (whole number only) so 1 = $1

Minimum value = 1
Maximum value = 999999999999999

Note: If value is less than 100000, override field must be populated

If firm does not wish to report field, it must enter "NA"
If Asset value is less than 100,000, enter "#" in this field Enter current yield if available

Field is processed as a percentage so 1 = 1%

This is a signed numeric value up to 4 decimal digits

If not populated, MFQS system will process field as not available and send "NA" to downstream users
Enter estimated long term return (yield) if available

Field is processed as a percentage so 1 = 1%

This is a signed numeric value up to 4 decimal digits

If not populated, MFQS system will process field as not available and send "NA" to downstream users
Enter accrued interest if available

Field is processed in currency units so 1 = $1

Minimum value = 0.000001

Maximum value = 999999.999999

If not populated, MFQS system will process field as not available and send "NA" to downstream users
Enter Daily Dividend Factor if available

Field is processed in currency units so 1 = $1

Minimum value = 0.000001

Maximum value = 999999.999999

If not populated, MFQS system will process field as not available and send "NA" to downstream users
Populate field only if Daily Dividend Factor field contains numeric value

If Daily Dividend Factor is populated, enter "Y" if calculation includes non-market day's or "N" if factor is for given entry date only
Enter calendar date associated with valuation record

Enter date in M/D/YYYY format (no zero padding)

For MFU and MMC files, Entry Date may be current day's date or a prior calendar date up to 364 days in the past
Enter three character ISO code for currency unit

Enter "USD" for US Dollars

If not populated, MFQS system will process record as U.S. dollars
Enter CUSIP number assigned to instrument

Field must contain 9 alphanumeric characters

MFQS Instrument record (and MFQS Directory download file) shows the CUSIP as it was reported to Nasdaq on the most recent instrument application
MFU ZZZZX X MF R 100.25
100.25
NA

99999 #




1/25/2017 USD 000000000

Sheet 2: MMC
MessageType This worksheet reflects the MFQS valuation message format for money market funds only. Firms may use this document as a guide to create CSV files. Header row must be left as is. Instruction / sample rows, however, need to be removed from document before converting to CSV file format. Please note that Nasdaq requires that firms use one of the following naming standards for CSV valuation files: MPID_MFQSVersion_MessageType_UploadDate.csv MPID_MFQSVersion_MessageType_ UploadDate _FileTime.csv Please note that the current MFQSVersion is 0050. FundID Footnotes ReportingType AverageMaturity AverageLife NAV NAVOverride Yield7DayGross Yield7DayGrossOverride Yield7DaySubsidized Yield7DaySubsidizedOverride Yield7DayAnnualizedEffective Yield30Day Yield30DayDate DividendDaily DividendDailyAdjustment Assets AssetsOverride EntryDate Currency CUSIP CalculationTime
Enter "MMC" for Money Market Funds Valuation records

Enter MFQS Symbol for payload record

MFQS Instrument record (and MFQS Directory download file) shows the current symbol / fund ID
Enter MFQS footnote code(s) to denote special price calculation situations

Standard fund level codes include:
B = Sales or account charges may impact yield
F = T+1 Data Used For Calculations

Standard market driven codes include:
D = Capital Distribution
S = Stock Dividend
X = Cash Dividend / Interest
G = Redemption Gate In Effect
L = Liquidity Fee In Effect

See file upload specifications for full footnote code list
Enter MFQS reporting frequency code

R = Regular / Daily Calculation
I = Intraday Calculation

Note: For money market funds only, MFQS system allows firms to denote a calculation time for intraday updates for downstream display purposes
Enter Average Maturity in number of days

Enter value in standard numeric format or as "NA"

Field is processed as number of days. 1 = 1 day

Minimum value = 1
Maximum value = 364
Enter Average Life in number of days

Average life should be calculated in accordance with the SEC Money Market Reform Act

Enter value in standard numeric format or as "NA"

Field is processed as number of days. 1 = 1 day

Minimum value = 1
Maximum value = 364
Enter numeric value or "NA"

NAV is required field for mutual funds, NextShares, annuities, SPs, and AIPs

Enter NAV in standard number format for these asset classes

Field is processed in currency units so 1 = $1

Minimum value = 0.000001
Maximum value = 999999.999999

Redemption NAV is required for UITs (which should populate field as "NA")
Leave field blank for standard MFQS price validation logic

Standard validation logic compares NAV in file to prior NAV in MFQS system; rejects if difference is more than defined %

Enter # to override MFQS price parameter validation logic
Enter current Gross 7 Day Yield in numeric format or as "NA".

Gross 7 Day Yield based on average net income earned by the securities in the fund’s portfolio during the past 7 days. In accordance with the SEC definition, Gross 7 day yield should exclude capital changes and income other than investment income. In addition, Gross 7 day yield should not reflect a deduction of shareholders fees and fund operating expenses.

Field is processed as a percentage so 1 = 1%

This is a signed numeric value up to 4 decimal digits

If field is not available, enter "NA"
Leave field blank for standard MFQS price validation logic

Standard validation logic compares Gross 7 Day Yield in file to prior Gross 7 Day Yield in MFQS system; rejects if difference is more than defined %

Enter # to override MFQS price parameter validation logic
Enter Subsidized 7 Day Yield in numeric format or as "NA"

The subsidized yield reflects the yield calculation with expense limitation currently in effect.

Field is processed as a percentage so 1 = 1%

This is a signed numeric value up to 4 decimal digits

If field is not available, enter "NA"
Leave field blank for standard MFQS price validation logic

Standard validation logic compares Subsidized 7 Day Yield in file to prior Subsidized 7 Day Yield in MFQS system; rejects if difference is more than defined %

Enter # to override MFQS price parameter validation logic
Enter Effective Annualized 7 Day Yield in numeric format or as "NA"

The effective yield reflects the expected annualized yield assuming that any income earned was reinvested

Field is processed as a percentage so 1 = 1%

This is a signed numeric value up to 4 decimal digits

If field is not available, enter "NA"

If not populated, MFQS system will process field as not available and send "NA" to downstream users
Enter 30 Day Yield in numeric format or as "NA"

30 day yield value based on the SEC calculation methodology with expense limitation currently in effect

Field is processed as a percentage so 1 = 1%

This is a signed numeric value up to 4 decimal digits

If field is not available, enter "NA"

If not populated, MFQS system will process field as not available and send "NA" to downstream users
Enter calendar date associated with 30 Day Yield value in record

Enter date in M/D/YYYY format (no zero padding)

Enter Daily Dividend Factor if available

Field is processed in currency units so 1 = $1

Minimum value = 0.000001

Maximum value = 999999.999999

If not populated, MFQS system will process field as not available and send "NA" to downstream users
Populate field only if Daily Dividend Factor field contains numeric value

If Daily Dividend Factor is populated, enter "Y" if calculation includes non-market day's or "N" if factor is for given entry date only
Enter Total Net Assets value as numeric value or "NA"

Field is processed in standard currency units (whole number only) so 1 = $1

Minimum value = 1
Maximum value = 999999999999999

Note: If value is less than 100000, override field must be populated

If firm does not wish to report field, it must enter "NA"
If Asset value is less than 100,000, enter "#" in this field Enter calendar date associated with valuation record

Enter date in M/D/YYYY format (no zero padding)

For MFU and MMC files, Entry Date may be current day's date or a prior calendar date up to 364 days in the past
Enter three character ISO code for currency unit

Enter "USD" for US Dollars

If not populated, MFQS system will process record as U.S. dollars
Enter CUSIP number assigned to instrument

Field must contain 9 alphanumeric characters

MFQS Instrument record (and MFQS Directory download file) shows the CUSIP as it was reported to Nasdaq on the most recent instrument application
Enter NAV calculation time for instrument if available

Calculation Time must be reported in HHMMSS military time format for U.S. Eastern Time zone

Examples:
• 11:00 a.m. Eastern Time should be reported as "110000”
• 10:00 a.m., Central Time should be reported as “110000”
• 4:00 p.m., Eastern Time should be reported as “1600000”

If Calculation Time is not available, field should be populated as “NA”

If not populated, MFQS system will process field as not available and send "NA" to downstream users
MMC ZZXXX
I 35 33 0.9945
NA
NA
NA NA
NA
NA
1/25/2017 USD 000000000 100000
MMC ZZXXX
I 35 33 0.995
NA
NA
NA NA
NA
NA
1/25/2017 USD 000000000 110000
MMC ZZXXX
I 35 33 0.9965
-0.002
0.0025
0.0025 0.0026 1/20/2016 1E-06 N 123500000
1/25/2017 USD 000000000 163000

Sheet 3: DST
This worksheet reflects the MFQS message format for capital distributions for all MFQS asset classes. Firms may use this document as a guide to create CSV files. Header row must be left as is. Instruction / sample rows, however, need to be removed from document before converting to CSV file format. Please note that Nasdaq requires that firms use one of the following naming standards for CSV valuation files: MPID_MFQSVersion_MessageType_UploadDate.csv MPID_MFQSVersion_MessageType_ UploadDate _FileTime.csv Please note that the current MFQSVersion is 0050. MessageType FundID FundType GainShortTerm GainShortTermOverride GainLongTerm GainLongTermOverride UnallocatedDistributions ROC ROCOverride PaymentDate RecordDate DateEx ReinvestDate Action EntryDate Currency CUSIP
Enter "DST" for Capital Distributions records

Note: On Ex-Date, firms should also include footnote of "D" on valuation message to denote NAV capital distribution adjustment
Enter MFQS Symbol for payload record

MFQS Instrument record (and MFQS Directory download file) shows the current symbol / fund ID
Enter MFQS Instrument Type for payload record

MF = Mutual Fund
MM = Money Market Fund
UT = Unit Investment Trust (UIT)
EM = NextShares Exchange Traded Managed Fund
AN = Annuity
SP = Structured Product (SP)
AP = Alternative Investment Product (AIP)
Enter Short Term Capital Gain as numeric value or "NA"

Short Term Capital Gain is the portion of the total capital gain that is taxed to the shareholder as ordinary income under U.S. tax law

Short Term Capital Gain should be entered in standard number format

Field is processed in currency units so 1 = $1

Minimum value = 0.000001
Maximum value = 999999.999999

If not available, field must be populated as "NA"
Leave field blank for standard MFQS price validation logic

Standard validation logic compares Short Term Capital Gain in file to current NAV in MFQS system; rejects if difference is more than defined %

Enter # to override MFQS price parameter validation logic

Note: To prevent fat fingering, Nasdaq doesnot allow distribution amount to exceed the current NAV even if the override field is populated
Enter Long Term Capital Gain as numeric value or "NA"

Long Term Capital Gain is the portion of the total capital gain that is taxed to the shareholder at the long-term capital gains rate under U.S. tax law

Long Term Capital Gain should be entered in standard number format

Field is processed in currency units so 1 = $1

Minimum value = 0.000001
Maximum value = 999999.999999

If not available, field must be populated as "NA"
Leave field blank for standard MFQS price validation logic

Standard validation logic compares Long Term Capital Gain in file to current NAV in MFQS system; rejects if difference is more than defined %

Enter # to override MFQS price parameter validation logic

Note: To prevent fat fingering, Nasdaq doesnot allow distribution amount to exceed the current NAV even if the override field is populated
Enter amount of unassigned term gains

Unallocated Distributions should be entered in standard number format

Field is processed in currency units so 1 = $1

Minimum value = 0.000001
Maximum value = 999999.999999

If not available, field must be populated as "NA"

If not populated, MFQS system will process field as not available and send "NA" to downstream users
Enter amount of return of capital (ROC) to the instrument shareholders

ROC should be entered in standard number format

Field is processed in currency units so 1 = $1

Minimum value = 0.000001
Maximum value = 999999.999999

If not available, field must be populated as "NA"

If not populated, MFQS system will process field as not available and send "NA" to downstream users
Leave field blank for standard MFQS price validation logic

Standard validation logic compares ROC in file to current NAV in MFQS system; rejects if difference is more than defined %

Enter # to override MFQS price parameter validation logic

Note: To prevent fat fingering, Nasdaq doesnot allow distribution amount to exceed the current NAV even if the override field is populated
Enter payment date for the distribution

Field must be date in M/D/YYYY format (no zero padding) or "NA"

Field must be an actual calendar date within 364 days (past or future) of the current day's date

If not available, field must be populated as "NA"
Enter Record Date for the distribution; shareholders of the instrument as of this date would receive the distribution

Field must be date in M/D/YYYY format (no zero padding) or "NA"

Field must be an actual calendar date within 364 days (past or future) of the current day's date

If not available, field must be populated as "NA"
Enter Ex Date for the distribution

Date must be submitted in M/D/YYYY format (no zero padding)

Field must be an actual calendar date within 364 days (past or future) of the current day's date

Note: Because the MFQS processing logic is based on Ex-Date field, Nasdaq requires that MFQS pricing agent cancel and re-enter the distribution record (rather than correcting the record)

Enter reinvestment date for the distribution

Field must be date in M/D/YYYY format (no zero padding) or "NA"

Field must be an actual calendar date within 364 days (past or future) of the current day's date

If not available, field must be populated as "NA"
Enter distribution action for record:

N = New distribution
C = Corrected distribution
X = Canceled distribution

Note: Please enter the full record for cancelled and corrected entries

Because the MFQS logic is based on the symbol and ex-date fields, Nasdaq highly recommends that firms enter a MFQS Symbol or Ex-Date correction as two separate entries: a cancellation for the original entry plus a new entry with the corrected information
Enter the current day's date (or file upload date)

Date must be submitted in M/D/YYYY format (no zero padding)

For DST and DIV files, the EntryDate value must be equal to the current day's date
Enter three character ISO code for currency unit

Enter "USD" for US Dollars

If not populated, MFQS system will process record as U.S. dollars
Enter CUSIP number assigned to instrument

Field must contain 9 alphanumeric characters

MFQS Instrument record (and MFQS Directory download file) shows the CUSIP as it was reported to Nasdaq on the most recent instrument application
DST XZZZX MF 0.00025
0.0002
NA NA
1/25/2017 1/24/2017 1/25/2017 NA N 6/27/2022 USD 000000000

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet mfu this worksheet reflects the mfqs valuation message format for most asset classes firms may use document as a guide to create csv files header row must be left is instruction sample rows however need removed from before converting file please note that nasdaq requires one of following naming standards mpid mfqsversion messagetype uploaddatecsv uploaddate filetimecsv current fundid footnotes fundtype reportingtype nav navoverride offermarketprice offermarketpriceoverride navredemption navredemptionoverride wrapprice assets assetsoverride yieldcurrent eltr accruedinterest dividenddaily dividenddailyadjustment entrydate currency cusip enter quot records classesmutual funds unit investment trusts uits nextshares exchange traded managed fundsannuitiesstructured productsalternative products aips symbol payload recordmfqs instrument record and directory download shows fund id footnote code s denote special price calculation situationsstandard level codes include h deferred sales char...

no reviews yet
Please Login to review.