Gamestudio Links
Zorro Links
Newest Posts
sub group backtesting
by AndrewAMD. 09/25/21 13:11
Company holidays next week
by Frederick_Lim. 09/25/21 07:48
AlpacaZorroPlugin v1.1.0 Released
by DdlV. 09/24/21 12:05
Lapsa's very own thread
by Lapsa. 09/24/21 09:52
Directa Broker
by Grant. 09/24/21 07:30
Malfunction W1301
by pegamode. 09/24/21 06:23
Banca Sella Rest APi
by AndrewAMD. 09/23/21 16:54
AUM Magazine
Latest Screens
Tactics of World War I
Hecknex World
Scheherazade's Journey
Paradox Vector
Who's Online Now
7 registered members (7th_zorro, MegaTanker, Smon, dpn, jari, titanicpiano14, AndrewAMD), 488 guests, and 11 spiders.
Key: Admin, Global Mod, Mod
Newest Members
jpeigentower, TimExcellent, Arkom, Raven478, SebVer
18685 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Error 047: No bars to plot (how to solve this issue) #483725
07/17/21 14:49
07/17/21 14:49
Joined: Mar 2021
Posts: 25
Casablanca, Morocco
anissyo Offline OP
Newbie
anissyo  Offline OP
Newbie

Joined: Mar 2021
Posts: 25
Casablanca, Morocco
Hello friends, i use the script csvtohistory to convert csv files to t6 files, it is working great for forex data from histdata or crypto data from the binance api, now i decided to test data from another api for us intraday stocks, when i downlaod the data into a csv file and i enter the correct string format in the csvtohistory script i get this message as a result of the convertion :

2733173 lines read
D:\histo\historicalzorro\AAPL.US_historynew.t6



but when i try to open the file it's not working i get this message error :
Chart compiling.......... t6 AAPL.US_historynew
Error 047: No bars to plot


what i did so far to make things work but with no luck :


1) i test with this five string format :
string Format = "+%Y-%m-%d %H:%M:%S;f3;f1;f2;f4;f6";
string Format = "%Y-%m-%d %H:%M:%S;f3;f1;f2;f4;f6";
string Format = "-%Y-%m-%d %H:%M:%S;f3;f1;f2;f4;f6";
string Format = "+-%Y-%m-%d %H:%M:%S;f3;f1;f2;f4;f6";
string Format = "-+%Y-%m-%d %H:%M:%S;f3;f1;f2;f4;f6";


2) i added the symbol 'AAPL.US_historynew' to assetsfix.csv


3) i checked the order of the lines in the history file to see if there is any thing wrong in the time and date, but my python script returned that the order is 100% correct there is no problem related to time not being in consecutive order



after strugling for this for roughly 3 days, i ask the community for help, thank's in advance

Re: Error 047: No bars to plot (how to solve this issue) [Re: anissyo] #483735
07/19/21 12:35
07/19/21 12:35
Joined: Jul 2000
Posts: 27,620
Frankfurt
jcl Offline

Chief Engineer
jcl  Offline

Chief Engineer

Joined: Jul 2000
Posts: 27,620
Frankfurt
We can't say it often enough: File names with special characters are always a bad idea. You can use underscore, but many windows software tools don't like dots, slashes, spaces, or similar.

It that's not the problem reason, look in the t6 file with the History script or the History Viewer. You can then probably see what's wrong, such as invalid time stamps or wrong order.

If all fails: We also have a data conversion service.

Re: Error 047: No bars to plot (how to solve this issue) [Re: anissyo] #483786
07/25/21 17:47
07/25/21 17:47
Joined: Mar 2021
Posts: 25
Casablanca, Morocco
anissyo Offline OP
Newbie
anissyo  Offline OP
Newbie

Joined: Mar 2021
Posts: 25
Casablanca, Morocco
thank's a lot jcl, i fixed the issue by reversing the order in the csv file, instead of going from older dates to recent ones, i did flipped the file so that the first line be came the most recent bar, and in the CsvtoHistory file i used this string format: "%Y-%m-%d %H:%M:%S;f3;f1;f2;f4;f6"

the + in front of the string format was not working for me for some reason..., i am going also to stop using any dots, slashes, spaces, or similar, only underscore

sorry but i have never seen this thing about correctly naming t6 files...


Last edited by anissyo; 07/25/21 17:47.

Moderated by  Petra 

Powered by UBB.threads™ PHP Forum Software 7.7.1