Data import into MotiveWave

[nkorepal]

Hi,

I am a novice and learning about trading, and am struggling with some issue with MotiveWave.

I am trying to import csv file available at this location: https://www.kaggle.com/datasets/nishanthsalian/indian-stock-index-1minute-data-2008-2020

In particular, I am trying to import Bank Nifty (Indian Index) 1 minute time frame to MotiveWave and I am following steps shown in the instructional video. But after I import, I cannot see any candle stick chart. I am trying to upload /BANK_NIFTY_data/BNF_2010_2020.csv file from inside the extracted folder.

Kindly do check if you are able to import the file from your end or not. I cannot figure out exactly whats wrong.

Thank You,

Regards,
Nitin

 

[freelancer]

Hello, I experienced also some issue about importing data but I finally figure it out.
The format needed for the .csv file is like so : (if you have the instrument on the first column, delete that column)

<DTYYYYMMDD>​	<TIME>​	<OPEN>​	<HIGH>​	<LOW>​	<CLOSE>​	<VOL>​
20211231​	2159​	1.13685​	1.13685​	1.13667​	1.13667​	154370000​
20220102​	2203​	1.1369​	1.1369​	1.1369​	1.1369​	3750000​
20220102​	2204​	1.13689​	1.13689​	1.13689​	1.13689​	3750000​

And be careful about the data from the hours after midnight , they need to have 0s before like here :

20220102​	2357​	1.13726​	1.13727​	1.13726​	1.13727​	2320000​
20220102​	2358​	1.13727​	1.13727​	1.13726​	1.13727​	2250000​
20220103​	0000​	1.13726​	1.13731​	1.13726​	1.1373​	24360000​
20220103​	0001​	1.13731​	1.13733​	1.13724​	1.13725​	15750000​
20220103​	0002​	1.13725​	1.13729​	1.13723​	1.13729​	8700000​

Otherwise you're going to see only from 10 o'clock the morning because 9h59 = 959 instead of 0959.
Do add the 0s before, with LibreOffice at least, you can go to Format Cells (Ctrl+1) then Leading 0, enter 4 and press ok. It'll add them and you'll be okay