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... History of dividend payment for stocks in the US stock market Rank Industries based on the average Relative Strength Index Moving Average Crossovers In the Past Trading Days	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 calculate the average of a time series using the money man... How to optimize the number of positions in a trading system How to automate the data downloading process
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 comp function not working ok in 2.0.2? Plotting the data from custom -Intraday data base	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 QuantShare Trading Software: New Features in the 3.3.2 Version