Viewing a thread - Trying to pull commodity price into a google sheet

Forums | Classifieds (186) | Skins | Language

You are logged in as a guest. ( logon | register )

Trying to pull commodity price into a google sheet	View previous thread :: View next thread
Forums List -> Computer Talk	Message format

jwadel88

Posted 1/27/2023 12:21 (#10063190)
Subject: Trying to pull commodity price into a google sheet

SC KS

I am trying to pull december corn price into google sheets. This is the function I am using =GOOGLEFINANCE("CBOT:ZCZ23") the value returns as #NA Error: when evaluating GoogleFinance the query for the symbol returned no data.

I guess I am wondering what I am doing wrong and if someone has successfully pulled commodity prices into google sheets.

Thanks!

Trying to pull commodity price into a google sheet - jwadel88 : 1/27/2023 12:21
- RE: Trying to pull commodity price into a google sheet - aquafina : 1/30/2023 10:38
- Interesting topic - found this resource with clues - YawLes : 1/30/2023 13:54
- RE: Trying to pull commodity price into a google sheet - Roger416 : 1/30/2023 20:41
  - CME/CBOT data sets - Agricultural - YawLes : 2/1/2023 11:37
- Still working on method to import markets into Google Sheets - YawLes : 2/2/2023 16:36
  - RE: Still working on method to import markets into Google Sheets - jwadel88 : 2/10/2023 13:09
- RE: Trying to pull commodity price into a google sheet - H3f : 2/16/2023 22:04

Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)