Hi,
I have a Dataset that's tied to Ameritrade. Most of the stocks in WL have matching values to what I see in ThinkOrSwim as well as the NASDAQ and NYSE websites.
However many don't. Can you give me any guidance as I'm assuming that I have not set something up correctly.
SATL is just one example. WL's Charts-when connected to Ameritrade- shows 12/8/23's close as 2.25. Everyone, including Ameritrade, says it was 2.30. This is playing havoc with my Strategy.
Thanks!
I have a Dataset that's tied to Ameritrade. Most of the stocks in WL have matching values to what I see in ThinkOrSwim as well as the NASDAQ and NYSE websites.
However many don't. Can you give me any guidance as I'm assuming that I have not set something up correctly.
SATL is just one example. WL's Charts-when connected to Ameritrade- shows 12/8/23's close as 2.25. Everyone, including Ameritrade, says it was 2.30. This is playing havoc with my Strategy.
Thanks!
Rename
1. Except for advancing the intraday interval timestamp, WealthLab doesn't change data retrieved from providers.
2. TD's ToS doesn't use the same public API that WealthLab must use. Who knows if the data source is the same for both on the back end?
3. In the example you gave, TD returned 2.30 for me.
Now, if you look at an intraday chart, you'll find that 2.25 was the last trade on 12/8. There's absolutely no guarantee that the last trade will be the settled close.
An explanation of what happened is that you requested the Daily chart before TD corrected for the settled daily close. WealthLab caches this data and won't update it again, which is unlike other realtime trading apps that always get a "fresh set" of data with each request.
For a single case, you can right click the chart and edit the data. But since you said you've observed multiple cases, you can use the Data Manager's Data Truncation feature. The next request will retrieve the latest/corrected data.
2. TD's ToS doesn't use the same public API that WealthLab must use. Who knows if the data source is the same for both on the back end?
3. In the example you gave, TD returned 2.30 for me.
Now, if you look at an intraday chart, you'll find that 2.25 was the last trade on 12/8. There's absolutely no guarantee that the last trade will be the settled close.
An explanation of what happened is that you requested the Daily chart before TD corrected for the settled daily close. WealthLab caches this data and won't update it again, which is unlike other realtime trading apps that always get a "fresh set" of data with each request.
For a single case, you can right click the chart and edit the data. But since you said you've observed multiple cases, you can use the Data Manager's Data Truncation feature. The next request will retrieve the latest/corrected data.
@steinh - for reference see: https://www.investopedia.com/ask/answers/09/closing-price-last-traded-price.asp
Thank you, both. I would have thought Update DataSet would bring the DataSet up to date. Deleting the DataSet, and downloading it again fixed the problem for those days.
I'll try experimenting with Check Data Integrity, Perform Data Cleanup, and when to re-download the DataSet at the best time. I only need a few days worth of data, so it should not take too long.
I appreciate everybody being there when we need help!
I'll try experimenting with Check Data Integrity, Perform Data Cleanup, and when to re-download the DataSet at the best time. I only need a few days worth of data, so it should not take too long.
I appreciate everybody being there when we need help!
Checking data integrity/cleanup won't help you with finding or adding data corrections to Daily bars.
But if you need to get corrections, you can delete the last bar for every symbol in the the DataSet, and then run your strategy again to update.
Or, just make sure you don't update until your provider finishes adding corrections - some don't do it until after midnight.
But if you need to get corrections, you can delete the last bar for every symbol in the the DataSet, and then run your strategy again to update.
Or, just make sure you don't update until your provider finishes adding corrections - some don't do it until after midnight.
Your Response
Post
Edit Post
Login is required