MF Portfolio File Converter : AI Schema Detection

Name of File: No file selected

Cash-Dervt/Diff Amt	Waiting...	Schema-Main/gemini-2.0-flash-001	Waiting...
Total Quantity/ txt file	Waiting...	Schema-Validation/gpt-4.1-mini	Waiting...
T-MV / txt file	Waiting ...	T-MV-Main/gemini-2.0-flash-001	Waiting...
Num. Records	Waiting ...	T-MV-Validation/gpt-4o-mini	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

web stats