Hi,

I would like to know if it is generally possibly to access Google-Spreadsheets from a NT-Strategy.
I downloaded the Data-API from Google, referenced all the dll-Files and tried to run a sample code.
The error I get is only the message that a reference is missing. No more errors in any logs or tracefiles.
The error occurs during runtime.

Is it possible to access a spreadsheet from a strategy? Does someone have a code sample for me?

Thx
DarthTrader

DarthTrader 

Hi, I would like to know if it is generally possibly to access Google-Spreadsheets from a NT-Strategy. I downloaded the Data-API from Google, referenced all the dll-Files and tried to run a sample code. The error I get is only the message that a reference is missing. No more errors in any logs or tracefiles. The error occurs during runtime. Is it possible to access a spreadsheet from a strategy? Does someone have a code sample for me? Thx DarthTrader

Post the full error message.

Have you tried right-clicking in the editor window, and adding the reference (point to the DLL path)?

Mike

I created in the past a Strategy which was sending SMS (using Google agenda API ), it was working well.

That is the problem. the only message in output-window, logs or traces is:

**NT** Error on calling 'OnStartUp' method for strategy 'GoogleSpreadsheetTest/d0cc6e487abd4d7bbb5a92b8f4a3d16e': Die Datei oder Assembly "Google.GData.Spreadsheets, Version=1.9.0.0, Culture=neutral, PublicKeyToken=3f77feb76ff0d9a1" oder eine Abhängigkeit davon wurde nicht gefunden. Das System kann die angegebene Datei nicht finden.

**NT** Error on calling 'OnBarUpdate' method for strategy 'GoogleSpreadsheetTest/d0cc6e487abd4d7bbb5a92b8f4a3d16e': Die Datei oder Assembly "Google.GData.Spreadsheets, Version=1.9.0.0, Culture=neutral, PublicKeyToken=3f77feb76ff0d9a1" oder eine Abhängigkeit davon wurde nicht gefunden. Das System kann die angegebene Datei nicht finden.

Translationt: " ...Version 1.9.0.0 was not found or a reference to this file or assembly was not found ..."

I referenced the assemblies in the downloaded google-data-api:

C:\Programme\Google\Google Data API SDK\Redist\Google.GData.Client.dll
C:\Programme\Google\Google Data API SDK\Redist\Google.GData.Extensions.dll
C:\Programme\Google\Google Data API SDK\Samples\Google.GData.Spreadsheets.dll

I also tried to reference all the dlls in Redist-Folder from downloaded API, but the same error occured.

DT

I tried to code the project in SharpDevelop 3.2. Everything works fine with referencing the Google.GData.Client.dll and Google.GDataSpreadsheets.dll. This is the code to show all documents in your Google-Docs account:

 

Code

Console.WriteLine ("Connecting to Google Spreadsheets ..."); SpreadsheetsService service = new SpreadsheetsService("exampleCo-exampleApp-1"); service.setUserCredentials("USER", "PWD"); SpreadsheetQuery query = new SpreadsheetQuery(); SpreadsheetFeed feed = service.Query(query); Console.WriteLine("Your spreadsheets:"); foreach (SpreadsheetEntry entry in feed.Entries) { Console.WriteLine(entry.Title.Text); } Console.Write("Press any key to continue . . . "); Console.ReadKey(true);

In NinjaTrader it doesn't work. I copied the dlls to NT/bin/Custom but always the same errot, that the dll reference is missing. The error occurs at runtime, when starting the strategy on a chart, compile works so far.

DT

Thinking ....
So you did include the references to ALL the dll's like Mike said?

Are they .Net dll's because otherwise it doesn't work i think ?!?!

also did you include the using namespaces in your Ninja script like

using Google.Application.etcetc

Yes ... and yes ... I guess the downloaded files are .Net dlls.
As I mentioned above, no errors in SharpDevelop, only NT seems to have
a problem with referencing the dlls. Compiling works fine, after starting the strategy
I see the error in output window.

Data-API-Download: https://code.google.com/archive/p/google-gdata/downloads
Data-API-Getting-Started: https://code.google.com/intl/de-DE/apis/spreadsheets/data/2.0/developers_guide_dotnet.html
Complete-Sample: https://google-gdata.googlecode.com/svn/trunk/clients/cs/samples/spreadsheets/spreadsheetdemo.cs

I tried myself too, and I have the same problem with this Spreadsheets.dll .
No idea, maybe @gomi have an idea ?

If you look what Ninja does with process monitor (procmon.exe), you'll see it looks for external assemblies in the GAC (in windows\assembly) and NinjaTrader's bin folder (in Program Files).
So I think if you put the Google assemblies there, it should work better. A least it should load the assemblies.

On my PC I get AssemblyResolveEvents problems afterwards, but the asssemblies are loaded, and it may be specfic to my config though.