Importing stock that are not listed in traditional sources

English
1

Folks,
I have some stocks like SGBJAN26, this is not listed in any of our sources given in PP. And the prices are available here : https://www.nseindia.com/get-quotes/equity?symbol=SGBJAN26

  1. When I try to use the table option, nothing comes up.
  2. I tried adding this source in the “Settings” under Bookmarks as below
    https://www.nseindia.com/get-quotes/equity?symbol={tickerSymbol}
    This link works when I right click on the security and I get to chose this link. But this link does not come in the drop down as a Quote provider while setting up the historical quotes
  3. I tried to “Link to Portfolio Report” by right clicking this and it says invalid URL and the URL it shows is “https://www.portfolio-report.net/”

Please suggest some options
Fantastic Tool helping so many of us

Cheers

2

Maybe you can use the data-link from
https://www.bseindia.com/stock-share-price/sovereign-gold-bond-2018-serie/sgbjan26/800282/corporate-governance/
The data-link is https://api.bseindia.com/BseIndiaAPI/api/getScripHeaderData/w?Debtflag=&scripcode=800282&seriesid=

Search the forum for JSON maybe it helps

EDIT: Sorry, I have not seen that you are talking about historical quotes - above is for actual quotes

3

I have found

https://www.nseindia.com/api/historical/cm/equity?symbol=SGBJAN26&from=&to=

Kann hier mal ein JSON-Auskenner gucken wie die JSON-Pfade zu Datum (CH_TIMESTAMP) und Kurs (CH_CLOSING_PRICE) zu setzten sind? Datumsformat müsste yyyy-MM-dd sein.

Can someone who knows JSON better than me check how to set the JSON paths to date and closing-quote?

4

Much appreciated Prog!!, waiting for any of our JSON champions to help me out on this

5

Even if an option is there to fetch the closing price, that would be really great

6

$data[*].CH_TIMESTAMP and $data[*].CH_CLOSING_PRICE should probably work :thinking:

7

Sorry to say, I could not get it worked. The date format is given, did not work. I removed the date format, still it did not work. Another thing is, when I click on the “Show server response” I get blank !!. But when I paste the URL in webpage I get all the details properly
URL used - https://www.nseindia.com/api/historical/cm/equity?symbol=SGBJAN26
What am I missing ??
image

8

NSE India has protected their API for unauthorised access, because when I try it, firstly I get figures but next time the server refuse the request.

9

Thanks so much. Guess that explains, why it is not working. Would appreciate if you can help on this one
URL is - https://api.bseindia.com/BseIndiaAPI/api/getScripHeaderData/w?Debtflag=&scripcode=800282&seriesid=
And the server gives the response just like when we paste it in the browser, but still I can not make it work.
image

10

I made some progress and am stuck at the date format. I am getting the date as 25 Nov 21 | 16:00, and when I give MMM for month, program is giving error message as below, where it is not even reading the MMM, it seems it recognizes only a numeric for month
Can I someone please help
The Api I used for this is : https://api.bseindia.com/BseIndiaAPI/api/getScripHeaderData/w?Debtflag=&scripcode=800282&seriesid=/Ason

image
image1202×912 111 KB