claude-code - 💡(How to fix) Fix [MODEL] building simple etl process to generate html dashboard for Trading from Fidelity [1 participants]

Preflight Checklist

• I have searched existing issues for similar behavior reports
• This report does NOT contain sensitive information (API keys, passwords, etc.)

Type of Behavior Issue

Claude ignored my instructions or configuration

What You Asked Claude to Do

for the last 3 to 4 weeks i request claude to build a dashboard using csv files and statement pdf from trading activity in Fidelity. I the begining i let AI run freely building a suggested dashboard using 3 files and everything seems to be fine and i was happy about the results on account balances, profit and loss and expandable trees in the dashboard. However, i received a complaint when i was told the totals dont match at all, about 13k difference.

since last week may 8, i decide to take control reviewing what the ai was doing and there was a comboluted architecture. I though it was following some methodology but not, it wasnt and that may be my mistake letting ai to work freely. So, start telling to save my requirements, and every session i noted a different behavior happened even i kept telling ai to read your memory. Sometimes we have to repeat all over again because is was doing whatever it wanted and wasted my tokens and money to rebuild all over, totals never matched. Last 5 days had to spend lots of hours tokens and money to rebuild all over again think a dimensional data model may be helpful but same problem. 3 days ago i decided to take more control on the design and told ai to build me a data model of the db it was using to see what exactly was building in the db end. I decided now to create an ER data model with an ETL process to load 4 simple files store them in stage tables and took another decision by itself, i requested a sequential identity column but it created a hash key to avoid duplicate reloade, but i told to load everything and kept filtering data. i lost all morning under assumption it was taken all data but no. this afternoon session i discovered that it kept using the hash key to filter dups. we were building an architecture, design, dictionary files. the session this afternoon told me that hash key was used and we were missing data, and requested again to use identity as pk and it needs to load all data. i got so frustraded about all hours of effort until 4am trying to build this simple process. if i would done it myself it would take me couple of days, not weeks using ai. i am professionally looking as not capable to use ai. i am really upset.

i know i have to continue working with this but it doesnt follow instructions and doesnt understand metodologies.

i dont know what policy you have but I want my tokens back or my money back to continue working. i am stuck with this platform with all the time and effort for all the work done.

AI told me to add this Today's date: May 19, 2026 The specific failures: archive folder incident, repeated architecture violations despite documented .md files, morning session lost Business impact: financial data system, incorrect P&L, real money

Please let me know. Regards

What Claude Actually Did

not follow my instructions, doesnt read the design instructions and requirements, doesnt follow the instructions or mis interpretate

Expected Behavior

match account balance total from fidelity broker csv and pdf files for transactions

Files Affected

it asked me persion for every step

Permission Mode

I don't know / Not sure

Can You Reproduce This?

Yes, every time with the same prompt

Steps to Reproduce

No response

Claude Model

Sonnet

Relevant Conversation

Impact

High - Significant unwanted changes

Claude Code Version

4.6

Platform

Anthropic API

Additional Context

No response