How to add/import custom trading details from spreadsheet (csv) to jstock about jstock HOT 5 CLOSED

Import history data feature is not available yet.

from jstock.

WARNING: this answer is a HACK and you are on your own if you mess up your data...

Having said that, almost all JStock data is stored in simple CSV files. Look under your "Documents and Settings" (XP) or Users (Vista, 7, etc) and eventually you will find a .JStock folder. A la [Documents-n-Settings][YourUsername].jstock\1.0.7....

Have a peek in there and it is fairly straight forward to sort out where the various bits are stored. As these as just simple CSV files you can edit them manually or use the ETL tool of your choice to automate it and do it on a repeatable fashion.

BUT BE CAREFUL! Some advise...

1. Make note of the line ends. From my brief inspection I can't tell if the are CR or LF but it certainly isn't both (the windows standard). My guess is that they are the Unix standard whatever that is; either CR or LF.

2. be sure that JStock is NOT running when you edit these directly. You would risk corrupting your data if JStock was running when you tinker with them directly.

3. Look closely at your existing JStock data to understand how the data should be formatted, eg date formats, etc.

4. And finally, and this should be obvious... DO A BACKUP BEFORE YOU START MUCKING AROUND!

Good luck,
-randall

from jstock.

@yccheok thanks for the quick reply and please consider this option in the next version.
@RandallSell I am not worried about the hack even if it caused any problem i can reinstall jstock. But i am using a ubuntu system and I dont know how to link the csv. from your hints i have tried this sofar

In ubuntu jstock has a hidden folder in the home directory home/.jstock and i am able to find out my stock details here home/.jstock/1.0.7/country_name/ and inside it has four folders databases, history, portfolios and watchlist. Inside watchlist folder there is another folder called "my watchlist" with a file realtimestock.csv. and inside "history" folder there are some csv file with filename similar to 3002w.LY B-start..csv and its content looks like this

code=3002w.LY               
symbol=My Industries                    
name=My Industries                  
board=Unknown                   
industry=Unknown                    
Date        Open    High    Low Close   Volume
Dec 29, 2014    17.6    18.55   17.6    17.1    1818580
Dec 30, 2014    17.9    18.35   17.75   17.9    2823011
Dec 31, 2014    17.95   18.1    17.1    17.15   2367274
...
...
...

My guess is that our watchlist pimary details are saved inside realtimestock.csv and historical data's inside "history" folder as a csv. But how to link realtimestock.csv to history/3002w.LY B-start..csv .

from jstock.

Well, I guess my short answer is - you can't. there is no "inter-linking" of these CSVs. I was merely pointing out that the storage of the JStock data is fairly basic, meaning it can easily be manipulated/hacked by third party tools.

-randall

from jstock.

K thanks for the answer any way i will try to hack myself and let you know if succeeded :)

from jstock.