Database, debugging with VS 2010, fundamental API, Excel?
Author: tradercn
Creation Date: 6/22/2011 4:44 PM
profile picture

tradercn

#1
Hi Eugene,

Can I debug my WLD Script with VS 2010? How to do that if it possible? Thanks.

I try to import 1500 stocks in China stock market. They belong to several categories, for example, provinces, industries, topics(or themes) etc. Can I store these categories in access database and load this database automatically when WLD is launched? Or, saying, can I program WLD script with ADO?

Next, I understand WLD doesn't provide fundamental data API, but I wish to get capital size, earning per share, and profit ratio increase per year, is that possible by creating my own provider? If it is possible where can I get information?

At last, if I would like to invoke MS excel in WLD? Is that possible? how to do that please? Thanks.
profile picture

Eugene

#2
Hi,

1. Not sure about scripts (see terminology), but strategies can be debugged with VS 2010. Be sure to target NET 2.0 when building the assembly. References:

* Wealth-Lab Wiki FAQ > Extensions (in the middle)
* How can I debug my trading strategies in Wealth-Lab?
* Debugging a Strategy with Visual Studio Express or SharpDevelop

2. Yes you can. The power of .NET is at your fingertips, so a strategy for sure can utilize ADO .NET. By the way, a short example of building an SQL Server database from a bunch of CSV containing historical data: Bulk import of data in CSV files to an SQL Server database

3. It does provide the fundamental data API. Like the broker API, it's not documented. Otherwise how would we be able to deliver the MSN and YCharts fundamental/economic data providers.

4. Yes it's possible. FAQ > Is there a way to read/write values to an open Excel sheet?
profile picture

abegy

#3
Is it possible to have an open source project example of a data provider extension which manages Fundamental data ?

Or if you don't want, can we have an upgrade of Database provider extension which allows to manage Fundamental data ?
profile picture

Eugene

#4
QUOTE:
Is it possible to have an open source project example of a data provider extension which manages Fundamental data ?

Well, maybe. While I am not keen on disclosing the YCharts provider source code, on my todo list there's a new fundamental data provider of a different type. I haven't started yet as other items are prioritized higher but once you see it released, give me a heads-up on making it open source.

P.S. Re: QuoteCenter, the ticket's open and maybe eventually we'll have the resources to get to this, one way or another.
profile picture

abegy

#5
Thank you very much !
profile picture

tradercn

#6
I have a question further.

For any price data from the real-time data provider, is that possible to read the changing price in MS Excel? Or, is that possible to write an Excel macro which to get the real-time price by calling functions from WLP as RTD?

Many thanks, Eugene.
profile picture

Eugene

#7
#1 - Sure it's possible, our DDE streaming Excel/OpenOffice provider (open source) does just that.
profile picture

tradercn

#8
My question is the reversed. For example, I can see the real time data in WLD, can I read it to Excel spreadsheet?
profile picture

Eugene

#9
No idea, really.
profile picture

Eugene

#10
profile picture

tradercn

#11
It is great. Tx, Eugene.
profile picture

fastrade

#12
QUOTE:
on my todo list there's a new fundamental data provider of a different type

Which one?
profile picture

Eugene

#13
Something not available before to Developer 5/6 users.
profile picture

fastrade

#14
is the name a trade secret? (LOL)
profile picture

Eugene

#15
Until I really get there through my list of projects to do, I'd prefer not to talk about and promise something.

I only talk when I'm 100% sure - otherwise CYA rules (LOL)
profile picture

Eugene

#16
QUOTE:
Is it possible to have an open source project example of a data provider extension which manages Fundamental data ?

Here we have it, an open source fundamental provider by your request:

Analyst Ratings provider from MS123 Extra Fundamental providers