Login Page - Create Account

Support Board


Date/Time: Sun, 08 Sep 2024 00:12:38 +0000



Post From: Quote Spreadsheet Row Limitation and ACSIL sc.GetBasicSymbolData query

[2024-01-28 18:52:38]
User150671 - Posts: 53
Good Morning,

I have noticed that Quote Spreadsheets will not get quotes for symbols past row 1001.
Is this by design?

I am trying to process between 1.5-2k quote symbols through Sierra into an an external application using the Spreadsheet Study as an in between.
I can obviously do this using two spreadsheets and studies if needed, but wondered if it was by design, or maybe a hang over from the old spreadsheets which had limited rows IIRC.

Semi-Related question regarding ACSIL as an alternative method:
If I created a ACSIL study which, on initial run only, iterated over a list of these quotes and called sc.GetBasicSymbolData with the SubscribeToData flag set on each one, would the end result be that a SCID file was created and updated for each symbol until sierra exited? This would be ideal.

EDIT:
I did not realise that Global Settings > Intraday File Update List existed.
I can simply spit out a symbol list from my application - load it into the Intraday File Update List, and then get a ridiculous amount of SCID files to iterate on.
This is perfect.
Date Time Of Last Edit: 2024-01-28 20:37:01