Support Board

Date/Time: Tue, 07 May 2024 20:57:57 +0000

Post From: Problem with study data being replaced with zeroes when chart tagged for recalculation

[2015-12-01 06:31:46] Link To Thread - Link To Post [Go To First Post]
User941434 - Posts: 39
You are correct, I did restart an instance of SC that is why the Time and Sales Bid and Ask study that output to my spreadsheet columns were all zero - even in row 3. When I re-visited this issue and compared before and after recalculation of the chart (rather than closing and opening the chartbook)I still had a weird result. The same row number cells for Time and Sales Bid and Ask study did not match and were way off the prices for the Bid & Ask Prices study for the same symbol? They were off by over 50cents per share on average for a $100 stock, and there were only half of the entries. In answer to your question above I have 7000 rows in my spreadsheet for trading. I will try the data recording suffix method you suggest as my goal is to have the bid ask data from "quotes" data rather than from "trade" data. The reason for this is that I am trying to compare bid and ask prices for two different stocks, one of which trades infrequently so the trade data is not sufficient for my trading model.