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 fx.practic, 10-15-2013, 12:53 AM
|
5 responses
5,404 views
0 likes
|
Last Post
by Bidder
Today, 12:22 AM
|
||
Started by Shai Samuel, 07-02-2022, 02:46 PM
|
4 responses
95 views
0 likes
|
Last Post
by Bidder
Today, 12:11 AM
|
||
Started by DJ888, Yesterday, 10:57 PM
|
0 responses
7 views
0 likes
|
Last Post
by DJ888
Yesterday, 10:57 PM
|
||
Started by MacDad, 02-25-2024, 11:48 PM
|
7 responses
159 views
0 likes
|
Last Post Yesterday, 10:23 PM | ||
Started by Belfortbucks, Yesterday, 09:29 PM
|
0 responses
8 views
0 likes
|
Last Post
by Belfortbucks
Yesterday, 09:29 PM
|
Comment