Click here to Login

Trading Software Trading objects Features How-to Blog Search


                                                   Excel Addin

  0

0
Andreia
2010-10-29 05:37:26


Is there an excel addin functionality or is there a way I can get the data into excel.

Thanks



QuantShare
2010-10-29 07:11:41

  0

Best Answer
There are several ways to export data:
- Select Data -> Edit, select a database and a symbol then click on Export to CSV.
- You can also use the Global Script to export all the data (Tools -> Script Editor)
- Or the Pivot Table Plug-in (Tools -> New Dashboard)

Once you have the data in CSV format you can import it easily into excel.



Andreia
2010-10-29 07:51:17

  0

Thanks!!! Lastlly, I downloaded the Nigerian Stock Exchnge Data but I cant seems to be a ble to locate the stocks or the index when I click Add Market.. I know I am probably doing something wrong and I will appreciate if you point me to the right direction


QuantShare
2010-10-29 08:08:03

  0

Which Nigerian Stock Exchange item have you used? and which "Add Market" button/item are you referring to?


Andreia
2010-10-29 08:14:12

  0

I used this http://www.quantshare.com/item-320-nigerian-stock-exchange and this http://www.quantshare.com/item-320-nigerian-stock-exchange# and installed them but I cantt locate the constituents stocks when i browse from quantshare software or when I click on Add Market.


QuantShare
2010-10-29 08:20:44

  0

To create symbols and download data:
- Select Download -> Download Manager
- Select the Nigerian Stock Exchange item
- Click on "Open"
- Select "Dates" then click on "Start"



Andreia
2010-10-29 08:28:35

  0

I have done that but How do I now view data. Thanks!!!


QuantShare
2010-10-29 09:38:53

  0

- Open a chart (View -> New Chart)
- Under the big icons, there is a control where you can select symbols



Andreia
2010-10-29 10:04:07

  0

Thanks finally got it working!!!!!


No more messages
0




Reply:

No html code. URLs turn into links automatically.

Type in the trading objects you want to include: - Add Objects
To add a trading object in your message, type in the object name, select it and then click on "Add Objects"










QuantShare

Trading Items
US Crude Oil Supply, Consumption, and Inventories
FAO Food Price Index
FTSE NAREIT US Market Real Estate Index Series - REIT Indices
AAII Asset Allocation Survey: Stock Funds, Stocks, Bond Funds, Bo...
NYSE Historical Volume Data

How-to Lessons
How to quickly select stocks based on the last value of a databas...
How to drag & drop indicators in charts
How to add a trading indicator to a chart
How to create a composite index/indicator
How to add a metric in the trading system simulation report

Related Forum Threads
Excel like import feature
Downloader needs Excel - Alternative?
Guru check this link
Couple of questions:
NORMDIST

Blog Posts
How to Create a List of Ticker Symbols
10 ways to download historical stock quotes data for free
How to search for a download item
How to create custom databases in your trading software
Pivot Tables in QuantShare Trading Software









QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright © 2012 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items