Click here to Login

                                                   Adding data to database through script


Obuli Govindaraju
2012-01-02 22:25:13

To add data to a database through a script I need to use DatabasesData along with Databases.SaveDatabaseData method.

So how do I add values to the DatabasesData? For example the code below throws an error."A readonly field cannot be assigned to (except in a constructor or a variable initializer)"

DatabasesData dbaseData;
Chart chart = Charts.GetSelectedChart();
ChartData chartData = chart.ChartData;
dbaseData.Symbol = chart.SymbolName;

2012-01-03 05:03:35


You should get a "DatabasesData" object using:

DatabasesData data = Databases.GetDatabasesData("Symbol Name", "MyDatabase", "MyField");

After that, you can update/add content by modifying:


Finally, you can save the data using:


Obuli Govindaraju
2012-01-03 22:21:13


ok, I get the concept. However how do I add something new to an empty database.

for example I get an error for the following code

data.Date = DateTime.Parse("1/1/1980");
data.Value = 56.78;

Cannot implicitly convert type 'System.DateTime' to 'System.DateTime[]'
Cannot implicitly convert type 'double' to 'object[]'

2012-01-04 05:54:14


Best Answer
In a new database, the arrays "data.Date" and "data.Value" are empty.

Here is how to add an entry:

data.Date = new DateTime[1];
data.Value = new Object[1];

data.Date[0] = DateTime.Parse("1/1/1980");
data.Value[0] = 56.78;

Obuli Govindaraju
2012-01-04 06:25:53


ok Thanks!

I got couple of more questions.

How is the array indexed meaning is the last row in the database indexed as 0 or first row as 0?

And second if a database has 2 fields do I have to provide date for both the fields or just one is enough?

2012-01-04 10:15:37


The first row has the zero index.

If the database has two fields then you should call "Databases.GetDatabasesData" twice (once for each field) and then update the "Date" and "Value" array of each one.

No more messages


No html code. URLs turn into links automatically.

Type in the trading objects you want to include: - Add Objects
To add a trading object in your message, type in the object name, select it and then click on "Add Objects"


Trading Items
Lagged Data From a Custom Database
Historical EOD data Downloader for Delisted/Bankrupt Stocks
Survivorship bias-free S&P 500 database downloader
Euronext Paris - Realtime Share Prices Data
Earnings database

How-to Lessons
How to use QuantShare with Metastock data
How to quickly download the most recent EOD data for your stocks
How to download and use U.S. stocks earnings data
How to export trading data to a CSV file
How to get stocks for a particular index using the global script

Related Forum Threads
Is it possible to delete database data through a script?
Can I update the sector and industry information in the stock dat...
Clear Symbol data stored in memory in global script
Data Interpolation c# Script
Deleting Data From The Database

Blog Posts
Speed Up Optimizations by Saving Ranking Data into a Custom Datab...
How to filter quotes data from high and low price spikes
4 Market Composite Indicators Based on Industry Data
Trading Items: Data Download using .Net Scripts
Step by step on how to get free realtime/delayed data for stocks,...

Create an account
Affiliate Program
Contact Us
Trading Forum
How-to Lessons
About Us
Terms of Use

Copyright 2024
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Follow us on Google+
RSS Trading Items

Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.