Reputation: 135
Is there an way to reference a cell inside a url in google sheets?
I'm trying to reference a cell inside a URL and I want to know whether it's possible or not. For example, this is my Import Json url.
https://www.alphavantage.co/query?function=TIME_SERIES_WEEKLY&symbol=MSFT&apikey=demo
And in A1, I have a value called "AMD".
Is it possible to replace MSFT with AMD by just referencing A1? What I have in mind is similar to this.
https://www.alphavantage.co/query?function=TIME_SERIES_WEEKLY&symbol=A1&apikey=demo
=ImportJSON("https://www.alphavantage.co/query?function=TIME_SERIES_WEEKLY&symbol=MSFT&apikey=demo")
Google Sheets
=ImportJSON("https://www.alphavantage.co/query?function=TIME_SERIES_WEEKLY&symbol=MSFT&apikey=demo")
Upvotes: 0
Views: 793
Answers (1)
Reputation: 27262
See if this works
=IMPORTJSON("https://www.alphavantage.co/query?function=TIME_SERIES_WEEKLY&symbol="&A1&"&apikey=demo")
Upvotes: 1
Related Questions
- Referencing a cell value as a parameter in the URL in Excel's Data From Web function
- FetchingURL Using JSON on Google Sheets v2
- How to get url from Google Spreadsheet cell with Google Apps Script?
- FetchingURL Using JSON on Google Sheets
- How to insert the URL for the specific sheet into a cell in a Google Sheets
- How to hyperlink an array of text using URLs in the sheet?
- Insert Dynamic Value in URL from a Cell in Google Sheet
- Is it possible to use a cell with a url linked object to trigger a function?
- Is it possible to capture GET? Method Data from a URL in Google Sheets?
- Calling a function inside an URL in Google Docs Spreadsheet