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.
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.
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.
0
