Convert Google Sheets Data into JSON URL using APP

[@shyamalsamanta1917]

খুব সুন্দর স‍্যার। অশেষ ধন্যবাদ আপনাকে। অনেক কিছু শিখতে পারছি আপনার ভিডিও দেখে।🙏🙏🙏🙏

[@santu..8133]

Great video ..... Thanks bro .. keep doing like this ...

[@vincenttrichy]

Excellent, Very very simple code, explanation clearly. Expect from you more google sheet sync with excel file both side sync.

[@sergeypedko3883]

this is really useful for me, you made my day! Really appreciate!

[@ismailal-smail1071]

❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

[@kunal_chand]

Amazing. Thanks bro!!

[@newsparkapps7478]

Really helped, Thank you so much

[@venkatesh1751]

thanks..

[@vampirekabir]

nested json possible?

[@cliff_fuhche]

very helpful. Please how do you return only results that match a query, and return everything if query is empty.

[@shovonds]

is there any limitations of execution limit ?

[@abdullahquhtani4247]

Is it possible to make make nested arrays for example student and his classes or doctor and his working days?!

[@StockDataAnalysis]

I think it can be done .. store array in cell insteed of value than probably u can do .....

[@glendertravel496]

Hi Great Video. How do you do it when you have different tables in the same sheet?

[@glhf426]

Hi I have an question when I try to type request it keeps showing me that python was not found.. May I know why is this happen? and the bottom Local is what and how to open it? Thanks

[@trushardesai4609]

I am using microsoft 365. i am not getting publish option. what are other option i will get url

[@atultanna]

Wont the data be delayed since it is on google sheet

[@StockDataAnalysis]

No once it ll update in Google sheet u ll find it in api

[@atultanna]

@@StockDataAnalysis How do i get in touch with you

[@atultanna]

@@StockDataAnalysis why don't you make one come video on the same with 5;8;26 and 200EMA in diff TF such 5 min 15 min 1 hr 4 hr and daily TF wih strate such as crossover ncpr ave 10 days vol 10 days ave delivery withvalerts RSI(3) greater than 80 and less than 20 and also where 5 8 and 26 EMA are where close together on daily and weekly charts

[@rtspigeons9951]

Hi... it is possible to add query in this script? for example we want to find Symbol=ASIANPAINT... the query is in the URL and the result only show the Symbol = ASIANPAINT... Thank You...

[@StockDataAnalysis]

Yes it's possible i ll make a video shortly

[@rtspigeons9951]

@@StockDataAnalysis Thank you so much... 🙏🏻🙏🏻🙏🏻🙏🏻

[@andyharewood7928]

Your video was easy to follow. Well done 👍👍 I did, however, encounter a problem. When it came to using the Web App URL my data is displayed incorrectly. Each record is displayed in following manner: [{"Column Header":"Cell Entry"," Column Header":"Cell Entry",etc…! } for all 200+ records. It is a mess. I have followed your instruction very closely even though it looks like you're using an old version of the Apps Script editor. However, when I click 'Run' in Apps Script my data is displayed in an orderly fashion which looks like a JSON layout. Apps Script did, however, truncate my data and returned a message saying "Logging output too large. Truncating output. " I don't know the first thing about coding. But I can follow a video very well. Could you please tell me how to fix this? I would attach pictures but I don't think it's possible on KZbin.

[@StockDataAnalysis]

i did it for 1000 rows still there is no problem ... plz try it in a new sheet...

[@andyharewood7928]

@@StockDataAnalysis Thx I shall try that and let yiu know how I get on 👍

[@bhanumanhas9551]

Great video ...is it possible to calculate rsi value in google sheets in single coloumn

[@StockDataAnalysis]

Thank you so much ......Yes it's possible then u need to import historical value ..

[@MrAJ-xx9gh]

Hi, thanks for sharing. If I need to add the spreadsheet data into object with comment as below structure could you advice what I have to add to the code? Thanks in advance. { comment1: "comment1 data", object: [ { Symbol: "symbol1", priceopen: 123, high: 456, low: 123, price: 345, volumn: 123456 }, { Symbol: "symbol2", priceopen: 123, high: 456, low: 123, price: 345, volumn: 123456 } ] }

[@aravindtrader]

ur video is very much useful i need to fetch first 15 min data...is it possible using api...

[@StockDataAnalysis]

Yes for that u have to set time range var now=new Date(); if(now.getHours() == 9 && now.getMinutes() >= 15 && now.getMinutes()

[@shrabanibhattacharya1899]

Can you develop an android app to screen stock for me plz..

[@StockDataAnalysis]

Message me @telegram with details I mean what type of screener and indicators. I ll try ....

[@spyboyyyyy]

How to create single json of multiple sheets of one document

[@StockDataAnalysis]

Yes just fetch multiple page data and put in json key as page name and creat by same code

[@punujena8454]

I need option chain in Google sheet

[@StockDataAnalysis]

Okk i ll try

[@yeasinarafat9160]

If I lose the api link how can I get the api link again? Plzzzzzz reply

[@StockDataAnalysis]

Publish again u ll get the link

[@svrthardware9038]

How to add parameter to this script Example ?id=1 to get only single Row Data by using parameter like ?id=1

[@buddhaline4258]

Hi, I have an error in this google script. Exactly match your type.. I can't see where I made a typo function myFunction() { var sheet = SpreadsheetApp.getActive(); var nse = sheet.getSheetByName("test"); var data = []; var rlen = nse.getLastRow(); var clen = nse.getLastColumn(); var rows = nse.getRange(1,1,rlen,clen).getValues(); for(var i = 0; 1 < rows.length ; i++){ var datarow = rows[i]; var record = {}; for(var j = 1; j < clen ; j++){ record[rows[0][j]] = datarow[j]; } data.push(record); } console.log(data); } TypeError: Cannot read property '1' of undefined

[@StockDataAnalysis]

WhatsApp me as a screenshot

[@buddhaline4258]

@@StockDataAnalysis I saw my typo....

[@Sashankabaidya]

Hello bro... Can u make a video on how to record banknifty open interest data in every 3 min interval in excel using xlwings in python.. Thanks in advance and egarly waiting for this video from u.. Thanks bro...

[@StockDataAnalysis]

I about to make a video on open interest tracker ... Any way thanks to suggest me it's really encourage me a lot ....

[@devwitheasy]

Is it free service or paid?

[@StockDataAnalysis]

Free

[@rithickchowdhury8729]

I am getting an error "Script function not found: doGet" after deployment. Please help

[@StockDataAnalysis]

Send me the screenshot @telegram

[@tanvinkhan5358]

Your video is very good. But, you're not provide source code.... You can provide source code more than helpful.

[@StockDataAnalysis]

Message me @telegram for source code

[@mubinafa]

Pérdida de tiempo, error en todas partes. Qué decepción, estos videos son inútiles.

[@MrDarrenfarrell]

Awesome, thanks you so much for sharing, however I keep getting an error when I run the code says "J" is not defined 4:22:01 PM Notice Execution started 4:22:02 PM Error ReferenceError: J is not defined doGet @ Code.gs:11 Here is the code: function doGet (e) { var sheet = SpreadsheetApp.getActive(); var menu = sheet.getSheetByName("Menuboard"); var data = []; var rlen = menu.getLastRow(); var clen = menu.getLastColumn(); var rows = menu.getRange(1,1,rlen,clen).getValues(); for(var i = 0; 1 < rows.length ; i++){ var datarow = rows[i]; var record = {}; for(var j = 1; j < clen ; J++){ record [rows[0][j]] = datarow[j]; } data.push(record); } }

[@lucapeduzzi4995]

for(var j = 1; j < clen ; J++) J++ should be j++