NinjaTrader Support Forum  
X

Attention!

This website will be down for maintenance from Friday May 24th at 6PM MDT until Saturday May 25th at 11AM MDT. We apologize for the inconvenience. If you need assistance during this time, please email sales@ninjatrader.com


Go Back   NinjaTrader Support Forum > Application Technical Support > Miscellaneous Support

Miscellaneous Support Miscellaneous support issues.

Reply
 
Thread Tools Display Modes
Old 02-27-2012, 12:55 PM   #1
looks
Junior Member
 
Join Date: Feb 2011
Posts: 3
Thanks: 0
Thanked 0 times in 0 posts
Unhappy Database error and google finance connectivity problem



The above occurs when trying to launch the 32-bit version - the database file exists just fine, as the 64-bit version runs off the same file.

With the 64-bit version, I am unable to get the intraday chart to pull/use the data feed from google finance, despite having confirmation of connection and actual download of data. This is even with the simpliest stock such as Apple/AAPL -> File -> New -> Chart, 1 min default setting. After the chart window comes up, there is no attempt of data refill message as it tries to back-fill or load any data, just blank. I have been using ninjatrader for futures (ES+cqg feed, no problem) and such behaviour is first time for me.

Please pics below: pic 2 ninjatrader log confirms good connection, pic 1 showing connection + just under 10 mbyte downloaded from google).




Any thoughts?


System Spec:

Win 7 64-bit SP1 fully patch (updated last week), Athlon64 x4, 16gig ram.
Last edited by looks; 02-27-2012 at 12:59 PM.
looks is offline  
Reply With Quote
Old 02-27-2012, 01:03 PM   #2
NinjaTrader_Matthew
NinjaTrader Customer Service
 
NinjaTrader_Matthew's Avatar
 
Join Date: Apr 2010
Location: Denver, CO, USA
Posts: 4,786
Thanks: 160
Thanked 567 times in 558 posts
Default

1) NinjaTrader requires various Microsoft components to run, one of which is SQL compact Edition. Currently you may not have SQL Compact Edition or possibly have the incorrect version of SQL Compact Edition installed for 32-bit, whereas the 64-bit has the correct version

Please follow the below steps to ensure the correct version of SQL Compact Edition is installed on your PC. If you are not entirely comfortable performing the steps below, please let me know and we can setup a time for a remote support session.
  • Navigate to the Windows Control Panel
  • Add and remove software/programs
  • Uninstall any SQL Compact Editions you see, if none are present you may ignore this step and continue onto the next step
  • Install latest SQL Compact Edition 3.5. SP2 which is available here: Download Here
  • Once you run the downloaded file it will ask you for a directory to extract the installer to. Point this to a temporary directory that you will be able to quickly locate later, such as the desktop
  • Navigate to the aforementioned directory in which the files have been extracted to (there will be two files)
  • SSCERuntime_x86-ENU.msi - Run this one first
  • SSCERuntime_x64-ENU.msi - No need to run this if you are on a 32 bit system, if you are on a 64 bit system you will also need to run this file, if you are not sure if you have a 64 bit system go ahead and run this file. If you are not using a 64 Bit operating system, the installer will cancel itself automatically
  • Follow the installation steps outlined in the installation wizard
  • Once installed you will need to restart your PC
  • You will now be able to launch NinjaTrader 7
If you are unable to launch NinjaTrader 7, please let me know and provide me with your phone number so that I may call you to further assist.


2) Google Finance does not offer intraday minute data. Please try loading a daily chart and let me know if the data backfills.
NinjaTrader_Matthew is offline  
Reply With Quote
Old 02-27-2012, 01:16 PM   #3
looks
Junior Member
 
Join Date: Feb 2011
Posts: 3
Thanks: 0
Thanked 0 times in 0 posts
Default

Thanks for the quite reply, Matthew.

Quote:
Originally Posted by NinjaTrader_Matthew View Post
1) NinjaTrader requires various Microsoft components to run, one of which is SQL compact Edition...
Bizare, I never had this problem with 7.0.2/3/4 previously. Anyway, good to know.


Quote:
2) Google Finance does not offer intraday minute data. Please try loading a daily chart and let me know if the data backfills.
Both yahoo and google finance offers real-time quotes, is ninjatrader unable to capture those in real time? I find that strange as ninjatrader manage to do that with many forex quotes.
looks is offline  
Reply With Quote
Old 02-27-2012, 01:22 PM   #4
NinjaTrader_Matthew
NinjaTrader Customer Service
 
NinjaTrader_Matthew's Avatar
 
Join Date: Apr 2010
Location: Denver, CO, USA
Posts: 4,786
Thanks: 160
Thanked 567 times in 558 posts
Default

Sorry - the Google Finance API version we use does not offer intraday historical data. You will only be able to request historical daily data with this version of the adapter.

Click here to view more information on Historical Data and Understand the data provided by your connectivity provider
NinjaTrader_Matthew is offline  
Reply With Quote
Old 02-27-2012, 01:33 PM   #5
looks
Junior Member
 
Join Date: Feb 2011
Posts: 3
Thanks: 0
Thanked 0 times in 0 posts
Default

Thanks Matthew, consider problem solved. I will look for an alternative.
looks is offline  
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Google Finance symbol map SigLogic Miscellaneous Support 1 07-20-2011 02:48 PM
Error During Historical Data download from Google Finance rain2010 Connecting 27 12-13-2010 07:01 AM
google finance external data feed riton Connecting 3 05-21-2010 06:06 AM
connect to BATS exchange / Google Finance mefTrader Connecting 1 03-31-2010 02:39 PM
Google Finance realtime quote and historical data eneratom Suggestions And Feedback 3 08-21-2008 09:37 PM


All times are GMT -6. The time now is 09:42 AM.