Database provider: partial bar doesn't fluctuate in Streaming
Author: OkyanusGrup
Creation Date: 1/7/2016 8:44 AM
profile picture

OkyanusGrup

#1
Dear All,

I am newbie here so please bear with my question. I'm having trouble setting the live streaming.

To give you clear explanation, let me give you an example;

By default, if you open a 60 min chart , you see past bars and current bar fluctating up and down (as far as I understand, you call it as ghost bar). I have past bars (it is ok) when I enable "Stream" button I see current bar but it does not fluctuate. Shouldn't it fluctuate ? Am I wrong ?

I have searched it in forum first, but I couldn't find any answer met my demand.

Thanks in advance..
profile picture

Eugene

#2
Hi Ozkan,

I believe you must be talking about your in-house streaming provider? If so, you might have programmed its streaming part incorrectly if its partial bar (ghost bar) is frozen. Give us more information to work with, please.
profile picture

OkyanusGrup

#3
Hi Eugene,

Yes my partial bar is frozen.

I use a Mysql database which is fed by Bloomberg-API continuously. So I can say that every ticker is updated in the database within 10 seconds while market is open.

I have set this table as a static provider and also streaming provider by following these instructions

Thanks
profile picture

Eugene

#4
Thanks Ozkan, now we found out that you're using our Database provider. Ideally, such important details save time if included right from the start.

1. First, make sure you've activated "Database" as the streaming data provider in Wealth-Lab's Preferences.
2. Then, double check that "Set up streaming data" contains correct settings on the Data Manager's Database provider tab.
3. Check the timestamps of streaming records in your database. Something is probably not right with their timestamps or with your PC clock. The main reason for what you're experiencing is that they aren't treated as real time records.
4. Also, please experiment with:
a. following all applicable Compatibility notes for MySQL in the Wiki online guide
b. replacing MySQL with SQL Server (Express will do).
profile picture

Eugene

#5
Hi,

Have you been able to make it work or do you need further assistance with this?
profile picture

OkyanusGrup

#6
Hi Eugene,

We have done everything that you mentioned. Unfortunately, we could not established streaming data.

Please see attached photos and steps that we did while trying to connect database.

MYSQL

Creating a New DataSet

MySQL database connection is established by following instructions located on your website.

Our Connection String:
Server=servername;Database=dbname;Uid=user;Pwd=pass; sql server mode=yes;

Please See Photo 1

Setting up Streaming Data

Our Connection String:
Server=servername;Database=dbname;Uid=user;Pwd=pass; sql server mode=yes;

Please See Photo 2

We set Market Manager and Preferences settings.

Please See Photo 3

MS-SQL

We have also downloaded Microsoft SQL Server 2014 for the double check purpose.

Creating a New DataSet

Our Connection String:

Data Source=192.168.1.33,1433;Network Library=DBMSSOCN;Initial Catalog=model;user id=user;password=pass;Current Language=us_english;

Please see Photo 4

P.S. We did this just for one stock.

Setting up Streaming Data

Please see Photo 5

Preferences and Market Manager settings were the same shown above.

Please see Photo 6 for Operating Logic of Our Bloomberg API

Although all the efforts we have done, we could not find a solution. Hopefully you will help us to solve this problem.

Thanks...
profile picture

Eugene

#7
Hi Ozkan,

Thanks for the walkthrough. The DB provider (streaming in particular) is set up to pull timestamps from the time field. However, looking at your gracefully provided database table snapshot I see that the timetamps there are delayed and supposedly represent the start of the bar's time. This is probably what upsets the streaming provider which only considers current timestamps. But the "time" field is delayed and not real-time. If it does not match your PC clock, the tick is discarded. I think this should explain the absense of streaming quotes.

Consequently, I suggest you set up the streaming provider using the entry_time field instead and then restart WL6 after applying this change. Hope that helps.
profile picture

OkyanusGrup

#8
Hi Eugene,

Finally, we have established streaming data by using entry_time field.

Thanks for your effort and help.
profile picture

Eugene

#9
I'm happy to have helped you.