Administration

COMPANY	QUALITY CONTROL	PARSING	HOLDERS	FILE TRANSFER	CLIENT SCRIPTS	SCRIPTS	DONORWATCH	INTITUTIONS	MUTUALFUNDS	LINKS

Update Settings Summary Contact Organizer	Pricing Q/A Blank Q/A Ratios Q/A Dashboards DonorWatch Transactions t1 Derivatives t2	form 3 S O H form 4 S O H form 5 S O H 13F 13F XML Derivatives-Dash Mutual Funds shares out 144/1 144/2	search filers form 345 problem 345 144 Filings	SEC All Filings companies 9th Digit Scrapers	• Altair blank blank blank	scripts predetermined e-mailing ranking splits Insert Pricing Problem & MV Pricing	update scripts login Sneak	update search scripts	update scripts Show Funds QA Dates QA Matching QA Calulation QA Division QA Archiving QA Cal. Run	email sec reports google sec archive overture

Show Mutual Funds That need to be Matched (This is so we know the large duplicate fullNames so we can match them.)

Refresh Page

Occurnaces

fullName MF Table

Mutual Fund Page

1st Company Name Found

1st compid

Relevence

2nd Company Name Found

2nd compid

Relevence

3rd Company Name Found

3rd compid

Relevence

SELECT count(*) as occurances, mutualFundall13ffilingsBrokenDown.filingValueRatio *mutualFundcurrent13Fpositions.value as realValueToDisplay, mutualFundall13ffilingsBrokenDown.filingShareRatio* mutualFundcurrent13Fpositions.shareAmount as realShareAmountToDisplay, round(((mutualFundall13ffilingsBrokenDown.filingValueRatio *mutualFundcurrent13Fpositions.value) /(mutualFundall13ffilingsBrokenDown.filingShareRatio* mutualFundcurrent13Fpositions.shareAmount )),2) as suggestedPriceByFiling, round(((mutualFundall13ffilingsBrokenDown.filingValueRatio *mutualFundcurrent13Fpositions.value) /(mutualFundall13ffilingsBrokenDown.filingShareRatio* mutualFundcurrent13Fpositions.shareAmount )),2) *98/100 as suggestedPriceByFiling_Low, round(((mutualFundall13ffilingsBrokenDown.filingValueRatio *mutualFundcurrent13Fpositions.value) /(mutualFundall13ffilingsBrokenDown.filingShareRatio* mutualFundcurrent13Fpositions.shareAmount )),2) *102/100 as suggestedPriceByFiling_High, floor(round(((mutualFundall13ffilingsBrokenDown.filingValueRatio *mutualFundcurrent13Fpositions.value) /(mutualFundall13ffilingsBrokenDown.filingShareRatio* mutualFundcurrent13Fpositions.shareAmount )),2)) as suggestedPriceByFiling_floor, mutualFundall13ffilingsBrokenDown.filingValueRatio AS filingBrokenDownfilingValueRatio, mutualFundall13ffilingsBrokenDown.filingShareRatio AS filingBrokenDownfilingShareRatio, mutualFundcurrent13Fpositions.entryId as mutualFundcurrent13Fpositions_entryId, mutualFundcurrent13Fpositions.linkID as mutualFundcurrent13Fpositions_linkID, mutualFundcurrent13Fpositions.compid as mutualFundcurrent13Fpositions_compid, mutualFundcurrent13Fpositions.value as mutualFundcurrent13Fpositions_value, mutualFundcurrent13Fpositions.shareAmount as mutualFundcurrent13Fpositions_shareAmount, mutualFundcurrent13Fpositions.checked as mutualFundcurrent13Fpositions_checked, mutualFundcurrent13Fpositions.fullName as mutualFundcurrent13Fpositions_fullName, mutualFundcurrent13Fpositions.fullRow as mutualFundcurrent13Fpositions_fullRow, mutualFundcurrent13Fpositions.closestPriceToFilingDate as mutualFundcurrent13Fpositions_closestPriceToFilingDate, mutualFundcurrent13Fpositions.singleEntryValueRatio as mutualFundcurrent13Fpositions_singleEntryValueRatio, mutualFundcurrent13Fpositions.singleEntryShareRatio as mutualFundcurrent13Fpositions_singleEntryShareRatio, mutualFundall13ffilingsBrokenDown.entryId as mutualFundall13ffilingsBrokenDown_entryId, mutualFundall13ffilingsBrokenDown.linkID as mutualFundall13ffilingsBrokenDown_linkID, mutualFundall13ffilingsBrokenDown.institutionid as mutualFundall13ffilingsBrokenDown_institutionid, mutualFundall13ffilingsBrokenDown.totalValue as mutualFundall13ffilingsBrokenDown_totalValue, mutualFundall13ffilingsBrokenDown.reportDate as mutualFundall13ffilingsBrokenDown_reportDate, mutualFundall13ffilingsBrokenDown.totalSecurities as mutualFundall13ffilingsBrokenDown_totalSecurities, mutualFundall13ffilingsBrokenDown.done as mutualFundall13ffilingsBrokenDown_done, mutualFundall13ffilingsBrokenDown.filingValueRatio as mutualFundall13ffilingsBrokenDown_filingValueRatio, mutualFundall13ffilingsBrokenDown.filingShareRatio as mutualFundall13ffilingsBrokenDown_filingShareRatio, mutualFundall13ffilingsBrokenDown.CheckBrokenDownSummary as mutualFundall13ffilingsBrokenDown_CheckBrokenDownSummary, mutualFundall13ffilingsBrokenDown.institutionidSub as mutualFundall13ffilingsBrokenDown_institutionidSub, mutualFundall13ffilings.entryId as mutualFundall13ffilings_entryId, mutualFundall13ffilings.institutionid as mutualFundall13ffilings_institutionid, mutualFundall13ffilings.reportDate as mutualFundall13ffilings_reportDate, mutualFundall13ffilings.archived as mutualFundall13ffilings_archived, mutualFundall13ffilings.done as mutualFundall13ffilings_done, mutualFundciklistBrokenDown.institutionidSub as mutualFundciklistBrokenDown_institutionidSub, mutualFundciklistBrokenDown.institutionCik as mutualFundciklistBrokenDown_institutionCik, mutualFundciklistBrokenDown.institutionName as mutualFundciklistBrokenDown_institutionName, mutualFundciklistBrokenDown.alive as mutualFundciklistBrokenDown_alive, mutualFundciklistBrokenDown.institutionid as mutualFundciklistBrokenDown_institutionid FROM mutualFundcurrent13Fpositions, mutualFundall13ffilingsBrokenDown, mutualFundall13ffilings, mutualFundciklistBrokenDown WHERE mutualFundcurrent13Fpositions.compid = 0 AND mutualFundcurrent13Fpositions.linkID = mutualFundall13ffilingsBrokenDown.entryId AND mutualFundall13ffilingsBrokenDown.linkID = mutualFundall13ffilings.entryId AND mutualFundall13ffilings.institutionId = mutualFundciklistBrokenDown.institutionIdSub AND mutualFundcurrent13Fpositions.fullRow NOT LIKE '%Bond:%' Group by fullName, suggestedPriceByFiling_floor HAVING COUNT(*) > 10 order by occurances DESC limit 1000