unable to get data Validating OHLC files WARNING: AARTIIND.NS.csv - Files must have Open, High, Low, Close and Volume columns Please correct the issues with the OHLC file and try again.

[umesht-Mum]

Hi

I am trying to use. My data is in format Date Open High Low close in 1st row than data starts in .csv file as follows

DATE | OPEN | HIGH | LOW | CLOSE | VOLUME
07/22/2024 | 660.1 | 699.7 | 660.1 | 697.65 | 1018872
07/23/2024 | 697 | 698.6 | 630 | 686.9 | 1418925
07/24/2024 | 685.55 | 696.65 | 682.85 | 691.25 | 447717
07/25/2024 | 687 | 693.9 | 682.35 | 690.9 | 447192
07/26/2024 | 696.9 | 713.55 | 691 | 707.45 | 975697
07/29/2024 | 707.45 | 724.8 | 707 | 715.8 | 1157342
07/30/2024 | 715.1 | 746.7 | 709.5 | 742.8 | 2926303
07/31/2024 | 743 | 754 | 736.85 | 748.85 | 1569283

I have again clone the stockepatterns from github and instead of using custom user json file i tried with setup-config.py where in 1st step only i got error

? Please provide the folder path to the OHLC data. Press Tab to autocomplete Documents\googlefinance\stock_data
Validating OHLC files
WARNING: AARTIIND.NS.csv - Files must have Open, High, Low, Close and Volume columns
Please correct the issues with the OHLC file and try again.

Kindly guide

AARTIIND.NS.csv

[BennyThadikaran]

I mentioned this earlier. Your column names are all upper case.

1. You need to rename the columns to Open, High, Low, Close, Volume
2. The file names itself must be lowercase. So AARTIIND.NS.csv -> aartiind.ns.csv
3. If your filenames have the suffix .ns you need to include them in the watchlist or whenever you pass the symbol name to scan. Ex. py init.py -p all --sym hdfcbank.ns

I suggest removing the .ns from the filename. So you can call py init.py -p all --sym hdfcbank

Hope this helps. Let me know if you run into issues.

[umesht-Mum]

Dear BennyThadikaran/stock-pattern Thanks its working now Thanks for the help Umesh Thakkar

…

On Tue, Jul 22, 2025 at 3:56 PM Benny Thadikaran ***@***.***> wrote: I mentioned this earlier. Your column names are all upper case. 1. You need to rename the columns to Open, High, Low, Close, Volume 2. The file names itself must be lowercase. So AARTIIND.NS.csv -> aartiind.ns.csv 3. If your filenames have the suffix .ns you need to include them in the watchlist or whenever you pass the symbol name to scan. Ex. py init.py -p all --sym hdfcbank.ns I suggest removing the .ns from the filename. So you can call py init.py -p all --sym hdfcbank Hope this helps. Let me know if you run into issues. — Reply to this email directly, view it on GitHub <#122 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BSKRBBHCXZSY5EMODK4D4XL3JYGTZAVCNFSM6AAAAACCB2SXZKVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTGOBUGYYDIMI> . You are receiving this because you authored the thread.Message ID: <BennyThadikaran/stock-pattern/repo-discussions/122/comments/13846041@ github.com>

[umesht-Mum]

Yes its working now thanks for the help.