can I hook up directly to the SQL database?
Status: Abandoned
Brought to you by:
okeuday
Menu
▾
▴
#4 can I hook up directly to the SQL database?
Very cool app!
Was wondering what the SQL db is and where it is? Would like to hook right up to it DIRECTLY from Excel (see Excel to SQL examples here
http://www.itsdoc.org/wiki/tiki-list_file_gallery.php?galleryId=2 ) are there database connectors to it and any idea on the connection strings? (or pointers to the documentation?)
Other "database" notes: would be good to export the ratings in numeric values and each in its own field (keeping the easy to read combined text field). Would also like the Tax at 15% binary field.
sqlite3 is used as the database backend in PreferredSearch. The application expects you to save the list of preferred stocks you are interested in as CSV (comma separated values) so that the data is easy to import into Excel or any other spreadsheet program. This workflow should be pretty typical for most analysis and is much easier than getting the data manually.
Currently storing the 15% tax rate hint but not displaying it, will change that soon. Could also expose the rating as a numeric value, since that is what it is internally.