MF Portfolio File Converter : AI Schema Detection

Go to MFpro open_in_new Advanced portfolio composition and return analytics. Fully automated pipeline: portfolio composition conversion, latest NAV, risk and return metrics. Run it on 100+ mutual funds at a time.

Name of File: No file selected

Cash-Dervt/Diff Amt	Waiting...	Schema-Main/gemini-2.5-flash	Waiting...
Total Quantity/ txt file	Waiting...	Schema-Validation/gpt-6-luna	Waiting...
T-MV / txt file	Waiting ...	T-MV-Main/gemini-2.5-flash	Waiting...
Num. Records	Waiting ...	T-MV-Validation/gpt-6-luna	Waiting...
TBD 2		TBD 1

Processing Logs open_in_full

open_in_full

warning Any cell turning orange with an icon indicates a validation issue that needs further review.

Field	Description
T-MV / txt file	Total market value from the created text file.
Num of records / txt file	Number of records from the created text file, used for validation against the ISIN count from the Excel file.
T-MV /gpt-4o-mini	Total market value from the input Excel file as identified by OpenAI model. Used for calculating Cash/Derivatives difference amount. Orange color indicates variance from Gemini value requiring review.
T-MV /'validation llm model name'	Total market value from the input Excel file as identified by the validation llm model chosen. Additional value obtained for validation purposes. Orange color indicates variance from OpenAI value requiring review.
Total Quantity/ txt file	Total quantity from the text file for validation purposes.
Schema /gpt-4o	Schema from OpenAI in format (e.g., 8-C-B-G-F): Row number followed by column letters for ISIN, Instrument Name, Market Value, and Quantity respectively.Used for data import
Schema /'validation llm model name'	Schema from validation llm model in same format as above. Additional schema obtained for validation purposes. Orange color indicates mismatch with OpenAI schema.
Cash/ Derivatives / Diff Amt	Balancing amount for non-ISIN items (cash, derivatives, TRIPS). Calculated as difference between Excel T-NAV (OpenAI) and text file T-NAV. Added as last line with ISIN IN9999999999.

mail Bugs, issues, questions? Drop a note: amar@harolikar.com

Manual Schema Override

Legend & Explanations