This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

GOOGLEFINANCE to LookerStudio

Posted on 09-23-2024 10:40 AM
PACAP
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi,
How to transfer the result of this Google Sheets function =GOOGLEFINANCE("GOOG"; "all"; today()-30; TODAY(); "DAILY") into a Loocker Studio datasource ?
My issue is that I ve no header into my sheets before the calculation

Thx four your thoughs

0 2 255
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
lauratilton
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

Looks like the formula creates headers (it did for me)...so you should be able to create a report using that Sheet as a data source...the headers will be there.

0 Likes

Posted on --/--/---- --:-- AM
PACAP
Bronze 1
Bronze 1
In response to lauratilton
Reply posted on --/--/---- --:-- AM

Hi,

Apparently a cache issue ! On this morning it's running correctly. How to refresh quickly ?

0 Likes