comp values stored as a separate field in the db

comp values stored as a separate field in the db

suresh
2010-09-06 10:15:21

I would like to automatically populate the database field, I am OK if this has to be achieved by running the update after I download the quotes. I would like to do something as follows:

create a field called "RSIRanking" in QUOTES or CUSTOM db
then populate the value using the function comp(RSI(14), "rank").

Thanks

QuantShare
2010-09-07 09:55:22

It will be possible to do this in the next release. I will show you how after the next version is released.

QuantShare
2010-09-16 05:16:11

Best Answer

You can find the script to perform this at the following link:
http://www.quantshare.com/free/composite_data_into_database.txt

(Tools -> Script Editor)

suresh
2010-09-16 06:41:49

Thanks. This should serve the purpose. I will test it out. A quick question

It appears to me that this will create the composites for all the days, every time I run this script. I want to see if there is any way this can be modified so that I can update on a daily basis the composite field quickly. The first time when I run, it does for the entire historical data and then only for the new data that does not have the field already populated.

QuantShare
2010-09-18 19:00:03

With this script, updating the last value or all the values of a database will take the same amount of time. We will optimize the database insertion so this script can be run faster.

You can also add a script to be executed after a download item completes. To do this, update a download item, click on Settings then select the Script tab.

Get more messages

No more messages

Back


Trading Items Set the First Trading Bar Values to Not a Number Update the Stock Exchange Associated With U.S. Stocks - Market Fi... High to low stock pattern for the close price Standard Error of the Estimate of a Regression Line Trading System based on the Linear Regression of the RSI Indicato...	How-to Lessons How to quickly select stocks based on the last value of a databas... How to plot the number of stock tweets per day How to display the number of notes per stock How to automate the data downloading process How to copy the data/settings of an account to another account
Related Forum Threads Can I predict values in the future Need some insight to the "rank" engine using comp funti... Why cannot see COMP results on chart and in debugger Automatically create field names for columns in ASCII import Arrow has the same properties as a trend line	Blog Posts Sentiment Analysis: How to measure the sentiment score of your st... Create a Pivot Table that displays the Relative Strength Index - ... QuantShare Trading Software: New Features in the 3.4.3 Version QuantShare Trading Software: New Features in the 3.4.2 Version 3 Items To Get and Trade the News In QuantShare Platform