BTSYNC Histo Price database

BTSYNC Histo Price database

in Black Lion Trading Co

Posted by: enjoyaol.2398

enjoyaol.2398

How it works
I have a dedicated server which every day, updates a whole historical price database for every TP item in GW2. It also creates PNG files for the historical prices, as well as a METASTOCK database to use in professional charting softwares.
(Ex: Amibroker is a software)

To get amibroker : http://www.amibroker.com/
The free version works fine, except you are limited in some stuff, like saving graphics, etc..

Installing bittorent sync :
To have the data up to date on your side, when the server updates it, you have to use bittorent sync. It’s a software that uses the bittorent protocol to synchronize directories across the internet.

Download bittorent sync for windows : http://www.bittorrent.com/sync

BTSYNC keys:
There are two keys you can use. You don’t have to use both, it really depends on what you want to do with the data.

1) The whole CSV historical prices for buy and sell price, as well as the PNG files generated by ‘R’ quantstrat module.
Around 15 GB, 111318 files
Read only key : B4WYVH3XSROPFZ5AEYCGX2VUMS2XNCKLF

Due to BT SYNC being unable to work properly with a myriad of small files, I replaced this key with this one, which leads you to download only one big .tgz file : BJYUP7OVPVVUYN45K3PAGOKPGYPNZP7EH

2) The Metaquote files around 50Mo in 4003 files
REad only key : B6XWQHDM4S33Z6DV7THFYCLWI6TZ2U5EK

Every folder contains a file named repo.txt which contains the item attributes if you need them.

Those keys are read only ones. If you modify or remove a file locally from the folder you synchronize with, it will be updated after a while (I guess) to match the server version.

How to import metaquote data in amibroker:

1) Launch amibroker
2) Menu File, Import Metaquote Data…
3) Button “Browse…”, then navigate to the file named MASTER in the metaquote folder (number 2 above)
4) Once the ‘ticker’ is filled, click on ‘import’ button
5) The window named ‘importing’ comes up and start importing the prices to amibroker
6) That’s it ! Items IDs appear on the left, and graphs on the right

Working with IDs:
To have the ‘human readable’ infos about an item ID, just navigate to http://www.gw2spidy.com/item/12860 and replace 12860 by the ID you want.
Or use repo.txt

Thanks to GW2Spidy API, I’m using that.

(edited by enjoyaol.2398)

BTSYNC Histo Price database

in Black Lion Trading Co

Posted by: enjoyaol.2398

enjoyaol.2398

Due to BT SYNC being unable to work properly with a myriad of small files, I replaced this key with this one, which leads you to download only one big .tgz file : BJYUP7OVPVVUYN45K3PAGOKPGYPNZP7EH