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.

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?

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 ?

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.

Thank you very much !

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.

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

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

No idea, really.

FAQ: Is it possible to use Wealth-Lab or one of its Extensions as a component in custom or 3rd party application?

It is great. Tx, Eugene.

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

Which one?

Something not available before to Developer 5/6 users.

is the name a trade secret? (LOL)

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)

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