Click here to Login

                                                   Updates to a custom database


2019-01-28 09:48:33

I have a custom database called mktcap, it only contains the date and the mktcap of a stock,
now I have noticed that each time I update the latest market cap of a symbol, a new row is created in the database for the latest date.
I only want the market cap for the last availble date. How can I ensure that only an update occurs on the database row
rather than an insert of a new row. This is just so that if I add other columns to the database which are updated less frequently,
then the other column data doesn't get lost on the latest update to market cap.

2019-01-29 08:11:56


In the pre or post script of the download item, you need to update the date field. Rather that using the date that is downloaded, you need to put a custom date diagrammatically.
Another solution would be to check the "Remove old data" option before downloading data. This solution would delete any existing data in the custom database before inserting new data.

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
Earnings database
Advanced Quotes and Custom Databases Function
Sum of a Custom Database's Field
Dow Jones U.S. Technology Sector Index Fund survivorship bias-fre...

How-to Lessons
How to quickly select stocks based on the last value of a databas...
How to use a custom drawing tool
How to create a custom trading indicator
How to add custom position-based metrics to your trading system
How to create a custom trendline

Related Forum Threads
Monthly/weekly summation for a custom database field
Composite tickers under custom database
Compress bar for custom database
Export Custom Database data - all symbols - including text fields
Can we create a custom database that without a Symbol relationshi...

Blog Posts
Speed Up Optimizations by Saving Ranking Data into a Custom Datab...
How to create custom databases in your trading software
QS Trading Software: Database Optimization
Custom Shortcuts - Move a Chart to Display the Last Quotes/Data
Trading System Analysis: Backtesting report and custom measures

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.