Announcement
Collapse
Looking for a User App or Add-On built by the NinjaTrader community?
Visit NinjaTrader EcoSystem and our free User App Share!
Have a question for the NinjaScript developer community? Open a new thread in our NinjaScript File Sharing Discussion Forum!
Have a question for the NinjaScript developer community? Open a new thread in our NinjaScript File Sharing Discussion Forum!
See more
See less
Partner 728x90
Collapse
NinjaTrader
importing cell from Google Sheets
Collapse
X
-
importing cell from Google Sheets
I have been trying to import a cell or cells from google sheets into my strategy without much success. Has anyone managed to figure this out? One option would be to export the cell from google sheets into a .csv file and have my script read this file, while the other that I see would be to directly access google sheet and scrape the data. On both ends I have been unsuccessful. Not looking to bring stock quotes just data that I want to assign into a variable within my script. Thanks in advance.Tags: None
-
Are you authenticating yourself correctly to Google?
Are you using a service account or your own user account?
Are you sure these steps are working correctly?
https://developers.google.com/sheets...es/authorizing
Reading a .csv file can be relatively simple and can be vastly easier to code.
Which one are you wanting to achieve first?
https://stackoverflow.com/questions/...-into-an-array
https://stackoverflow.com/questions/...-c-with-header
-
Originally posted by bltdavid View PostAre you authenticating yourself correctly to Google?
Are you using a service account or your own user account?
Are you sure these steps are working correctly?
https://developers.google.com/sheets...es/authorizing
Reading a .csv file can be relatively simple and can be vastly easier to code.
Which one are you wanting to achieve first?
https://stackoverflow.com/questions/...-into-an-array
https://stackoverflow.com/questions/...-c-with-header
Comment
-
Hello NFT-Trader,
Thank you for your reply.
I would agree with bltdavid here. While accessing Google Sheets is not officially supported, going the CSV route would be simpler. I agree that you're likely running into an authorization issue with Google Sheets - I'd check out those links he provided.
Please let us know if we may be of further assistance to you.Kate W.NinjaTrader Customer Service
Comment
Latest Posts
Collapse
Topics | Statistics | Last Post | ||
---|---|---|---|---|
Started by GussJ, 03-04-2020, 03:11 PM
|
11 responses
3,221 views
0 likes
|
Last Post Today, 08:07 PM | ||
Started by andrewtrades, Today, 04:57 PM
|
1 response
10 views
0 likes
|
Last Post Today, 05:02 PM | ||
Started by chbruno, Today, 04:10 PM
|
0 responses
7 views
0 likes
|
Last Post
by chbruno
Today, 04:10 PM
|
||
Started by josh18955, 03-25-2023, 11:16 AM
|
6 responses
438 views
0 likes
|
Last Post
by Delerium
Today, 03:42 PM
|
||
Started by FAQtrader, Today, 03:35 PM
|
0 responses
9 views
0 likes
|
Last Post
by FAQtrader
Today, 03:35 PM
|
Comment