Query and Usage Limits

Owned by Brendan Hebert (Unlicensed)
Last updated: Sept 11, 2023
1 min read

Below are the historical query and usage limits for Barchart for Excel.

End of Day (EOD)

DEFAULT_EOD

Daily

Hourly

DEFAULT_EOD

Daily

Hourly

 

50,000

5,000

 

Minute Data

DEFAULT_MIN

Daily

Hourly

 

20,000

2,000

 

Tick Data

DEFAULT_TIC

Tick_Days

Tick_Daily

Tick_Hourly

DEFAULT_TIC

Tick_Days

Tick_Daily

Tick_Hourly

 

30

5000

500

 

(Note: Historical data queries are capped at Excel’s maximum limit in terms of the total number of rows and columns in a worksheet at 1,048,576)

Related pages

Barchart for Excel User Guide
Barchart for Excel User Guide
Barchart for Excel
Read with this
Syntax and Functions
Syntax and Functions
Barchart for Excel
Read with this
Troubleshooting
Troubleshooting
User Guides & Support
Read with this
Equity Option Look Back
Equity Option Look Back
Barchart for Excel
Read with this