I am having an issue when trying to import the CSV file.

[mclemens8]

Hi,

I am trying to important the CVS file but it just simply isnt working. I downloaded the data, formatted it to be correct, and I still cant get it to work. It keeps returning "file not found" and then the cvs. Let me know what you think, I will attach the CSV.

Here is the error, (only a few lines)

[00:00<?, ?it/s]File not found: C:\Users\mclemens1\stock-pattern\date,close,open,high,low,volume.csv
2%|█▌ | 1/54 [00:02<02:16, 2.57s/it]File not found: C:\Users\mclemens1\stock-pattern\2022-02-23,20.21,21.88,22,20.19,36958180.csv
File not found: C:\Users\mclemens1\stock-pattern\2022-02-22,21.51,21.55,22.19,21.35,34908640.csv
CCL.csv

Let me know what the issue is,

Thank you!

[BennyThadikaran]

Your watchlist is setup wrong. You have provided a OHLC file for the watchlist. So each line of OHLC data is treated as a symbol name. Thats the reason for the weird file name below. C:\Users\mclemens1\stock-pattern\2022-02-23,20.21,21.88,22,20.19,36958180.csv Also CCL.csv must be lowercase. You can try `py init.py --sym ccl.csv -p all` If above is working well, create a watchlist.txt file with `ccl` on the first line and any other stocks you want to add (one on each line) ccl goog gs Run it like as below `py init.py -f watchlist.txt -p all` You can also add watchlist.txt in user.json. I have not run the CCL.csv but it seems fine. If you encounter any issues with parsing the date let me know.

On 18 November 2024 21:21:15 UTC, mclemens8 ***@***.***> wrote: Hi, I am trying to important the CVS file but it just simply isnt working. I downloaded the data, formatted it to be correct, and I still cant get it to work. It keeps returning "file not found" and then the cvs. Let me know what you think, I will attach the CSV. Here is the error, (only a few lines) [00:00<?, ?it/s]File not found: C:\Users\mclemens1\stock-pattern\date,close,open,high,low,volume.csv 2%|█▌ | 1/54 [00:02<02:16, 2.57s/it]File not found: C:\Users\mclemens1\stock-pattern\2022-02-23,20.21,21.88,22,20.19,36958180.csv File not found: C:\Users\mclemens1\stock-pattern\2022-02-22,21.51,21.55,22.19,21.35,34908640.csv [CCL.csv](https://github.com/user-attachments/files/17806399/CCL.csv) Let me know what the issue is, Thank you! -- Reply to this email directly or view it on GitHub: #86 You are receiving this because you are subscribed to this thread. Message ID: ***@***.***>

Regards, Benny Thadikaran

[mclemens8]

Hi! Funny you said I may find a parsing issue, I just got this issue

C:\Users\mclemens1\stock-pattern>py init.py -f watchlist.txt -p all
Scanning ALL patterns on daily. Press Ctrl - C to exit
0%| | 0/1 [00:00<?, ?it/s]ccl: Error loading file - ValueError("Missing column provided to 'parse_dates': '\ufeffDate'")
100%|████████████████████████████████████████████████████████████████████████████████████| 1/1 [00:00<00:00, 1.36it/s]
No patterns detected

[BennyThadikaran]

I was away from my PC when I first replied you. On second check there are a few issues with CCL.csv

1. You need to lower case the file names. (This is done because its tough to remember the exact case of filenames for 100+ files)
2. Your column names are all lower cased. You need it like Date,Close,Open,High,Low,Volume
3. If you use setup-config.py, make sure your data folder only has CSV files.

Finally, run py init.py -p batu --sym ccl. There is a nice BAT pattern detected on this one. 😄

Below is the edited OHLC file and the minimum config you will need to get going.

ccl.csv

{
  "DATA_PATH": "/home/benny/Desktop/ohlc"
}