How to import data from Excel and SQL databases?
Author: lparker
Creation Date: 5/20/2014 11:53 AM
profile picture

lparker

#1
Hi guys,

I have just downloaded the WealthLab Trial and was wondering if there any any other tutorials on its basic use other than the 2 101 vids on youTube.

Also, is it possible to import a dataset into WealthLab if I already have one?

Many thanks
Luke
profile picture

Eugene

#2
Hi Luke,

Give this a try:

FAQ: How do I get started learning Wealth-Lab?

QUOTE:
Also, is it possible to import a dataset into WealthLab if I already have one?

Which type of data do you have?
profile picture

lparker

#3
Thanks very much - I will take a look

I basically have an excel spreadsheet of open, close, high and lows on a daily basis of vaurous instruments.

I also have some intraday data if that is importable.

Thanks

profile picture

Eugene

#4
Excel files can be read directly using the Excel static data provider. However, since this is an extension (a customer-only option) and you're evaluating Wealth-Lab, there's one extra step you need to do. The data can be exported out of Excel into a CSV file and imported with the built-in ASCII provider. For more information, see the User Guide: Data > Data Manager > Create New DataSet > Data Providers > ASCII.
profile picture

lparker

#5
That is great. Works perfectly. I have a lot of data in an SQL database that I have updating automatically each day. Is it possible to have Wealthlab access that (to avoid me creating a new CSV file each day and them have WealthLab update from that).

Thanks
Luke

profile picture

Eugene

#6
Sure it's possible. In the Extension Finder section, switch Category to "Provider". One of the extensions you'll find there is the Database provider which supports any popular RDBMS like MS SQL Server, MySQL, Oracle, ODBC/OLEDB and more.