Common Problems w/ Google Sheets
ARTRANGEcall counts as 1 data pull, which is why we recommend using
ARTRANGEwhenever pulling large amounts of historical data. Syntax for
ARTRANGEis listed in:
When sharing sheets, be advised that the URL Fetch Limit counts towards the owner of the sheet. Therefore if you share a sheet, it is recommended you share it in View Only mode in order to reduce data pulls counted towards yourself.
Additionally, the credentials of a sheet are always read from the owner of the sheet. Therefore, if the owner of the sheet churns from their Artemis subscription, the sheet will no longer be functional until the viewer of the sheet makes a copy on their own account and thereby becomes the owner.
Google Sheets has a few performance limitations that ultimately reduce the quality of offering we can provide. Namely,
- The functions take
>400msto start running. This means for each function, we do not have control of execution until at least
- 1.Use our Excel plug-in whenever possible - neither of these performance limitations are imposed.
- 2.If not possible to use Excel, use
ART- this will reduce the burden of the listed performance limitations.
- 3.Share sheets in View Only mode.