Click here to Login





                                                   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
Equity and Date Export To Excel
Equity Export To Excel
Nepal Market - Daily Stock Quotes
Adaptive Asset Allocation Butler V1.3 AMM
TSP Sentiment Survey - Percentage of Bullish and Bearish Traders

How-to Lessons
How to automatically arrange charts?
How to calculate the average of a time series using the money man...
How to create a moving average of an indicator
How to plot the relative performance of several stocks/indices
How to import trades into a portfolio

Related Forum Threads
Excel COM Addin Not Loaded
Excel like import feature
Export to Excel
Download Multiple Ticker Information to Excel
An example for Excel COM automation - Further joint development?

Blog Posts
How to Send Commands to QuantShare from Excel or Other Applicatio...
Reading and Exporting Data from QuantShare to Excel Programmatica...
How to Display the Year-to-Date Excess Return in a Pivot Table
How to Create a Custom Real-Time Table using QS Trading Software
10 ways to download historical stock quotes data for free









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 © 2024 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.