Using SQL Server with Wealth-Lab
Author: disc999golfer999
Creation Date: 8/29/2010 9:45 PM
profile picture

disc999golfer999

#1
Record Date Strategy,

I wanted to add some additional fundamental items to initialize trading around a strategy.

It has to do with the Record Date of the security and the 30 day activity before that date.

I wrote a custom program that downloaded the Open/Close for the 30 Corporate Bond securities from Google. I built an excel report that told me the low and high in the 30 days before the Record date. I have measured the activity that happens when people are trying to get recorded so the bond can pay interest to them in the next cycle.

The problem is that some bonds have a Record Date the day before the payment date, or it is the last day of month prior, first day of the payment month, 15 days prior, etc...
Each security has it's own set of key dates.

Under the "Corporate Fundamental Data" the set does not include parameters so I can add my own key dates.

I want to use my SQL Server database and store that data and have the program check the current date and see what might be in play. Is that something I can do with Wealth Lab Pro?
profile picture

Eugene

#2
Sure, using any database is possible if you code a static data provider that would connect Wealth-Lab to it. Examples of already working solutions include COTCollector (works with a SQLite DB) and Zerich provider (which stores data for Russian markets in an SQL Server Express DB).

Shortly, we'll release our own Database provider extension that connects to any database supported by .NET provided a DbProviderFactory is available (ODBC, SQL Server, SQLite, you name it). Initial release will have limited support for custom data series (if any) though.
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).