| | | Well, my experience is you need more than one site, I must use three due to my problem with FRT data. So, here it is. Wall Street Journal Finance is always the accurate go to if you have a discrepancy. Problem is WSJ does not do a watchlist. I use Barchart for my watchlist of stocks. They also have a download link to a CSV Excell file. Problem with them is volume is always wrong so I copy FRT volume and paste into barchart volume column, and they do not adjust for dividends. FRT for me and Gman at times displays after market data and thanks to WEagle he never has that problem, so he emails us the FRT list. Problem for me is due to my special situation need to format the data FRT data cannot be formatted if the value is less than zero to red which I must have. I also always have at least 1 or 2 stocks with wrong price change from FRT, another problem just at my location.
So, here is what I must do to get 100% accurate data. First at 8:15 PM I go to Freerealtime.com and copy the watchlist, go to barchart select watchlist, click download Excell CSV file opens, skip one column use Paste special value TEXT into the sheet. Copy the price change column and paste next to barchart price change to compare. If a deference go to WSJ and get price change, IF there was a dividend use WSJ price. IF no dividend day I use barchart price as FRT is always wrong for my FRT data. So, takes me three websites to get accurate data takes about two minutes.
I have informed FRT of the problems for my location to FRT, nothing has been done for my location. So that is what I must do every night.
Example of what my download CSV file looks like below. I then copy the barchart data and paste into my CLIMAX model VBA format Excell spreadsheet. Friday PG was a dividend day Barchart had the price change at -0.52 so I changed it to WSJ price 0.54. Also NVDA FRT price was wrong, no dividend so Barchart price change was correct.
 |
|
