Dear Every one
There is an option of stock in data excel 365, there is a problem by using said option the stock market of other country's companies are showing, but i want to see the data of my country's company, in simple i wand to add my own country stock market in excel data stock, how can i add please help me, there is a attachment for understanding what i want to do
Hi Salim,
Here is a list of supported stock exchanges. Try prefixing your stock code with the market code, followed by a colon, then the stock code e.g. XASX:BHP
Mynda
Dear Mynda Treacy
i am very thankful you for the reply, kindly guide me option wise to add my country stock market in (stock option), sorry to say i did not understand the way you guide me, please help
Regards
Salim
Hi Salim,
You haven't said what your country is, but if it's not in the list I linked to above, then there's no way you can add it, sorry.
Mynda
Dear Mynda Treacy
Sorry for incomplete information, my country name is Pakistan, which is not in the list given by you, second one is my request to you please guide me option wise adding method in stock option, companies of selected countries arrives in stock information, i want information of my country stock market information in excel data stock option, i hope you will understand what i want, and help me as per my need thanking you
Salim
Hi Salim,
I understand what you want, but if Pakistan isn't in the list of supported country exchanges, then you can't just add it and there's no other way of getting the data using the STOCKHISTORY function.
You could try using the WEBSERVICE function, if you can find a web page that will provide the data.
Mynda
