- 35
- 41 686
PDSquare
India
เข้าร่วมเมื่อ 8 ก.ย. 2019
PDSquare
วีดีโอ
How to select stocks for trading. subscribe my channel for more videos from play list and new videos
มุมมอง 542 หลายเดือนก่อน
How to select stocks for trading. subscribe my channel for more videos from play list and new videos
How to get 5, 10, 15, 30 min, 1 hour data from Google finance to Google sheet with auto update
มุมมอง 1033 หลายเดือนก่อน
Don't forget to scribe my channel. If you like this video click the like button and share it to your friends. Note: Since greater than and less than symbol is not accepted by the youtube in discription. enter the symbol stop "greater than" 550 && stop "less than"955. see video at 9.38Sec for reference 1) First Open google sheet 2) In Column A1 paste the below formula =IF(A7=A9,"LEAVE",IF(A7=A10...
Williams %R Value of Stocks in GOOGLE SHEET with Autoupdate (Overbought/Over sold)
มุมมอง 8413 ปีที่แล้ว
Williams %R Value of Stocks in GOOGLE SHEET with Autoupdate (Overbought/Over sold)
How to get MACD and Histogram values of Stocks in Google sheet/ Copy and paste
มุมมอง 2K3 ปีที่แล้ว
How to get MACD and Histogram values of Stocks in Google sheet/ Copy and paste
HOW TO GET EMA VALUES OF STOCKS IN GOOGLE SHEET WITH AUTO UPDATE.
มุมมอง 15K3 ปีที่แล้ว
HOW TO GET EMA VALUES OF STOCKS IN GOOGLE SHEET WITH AUTO UPDATE.
RSI Value of Stocks in GOOGLE SHEET with Autoupdate (Overbought/Over sold)
มุมมอง 19K3 ปีที่แล้ว
RSI Value of Stocks in GOOGLE SHEET with Autoupdate (Overbought/Over sold)
How to select intraday stocks in 1min using Breakout
มุมมอง 2K3 ปีที่แล้ว
How to select intraday stocks in 1min using Breakout
paper trading in live market 23 sep bajfinance
มุมมอง 444 ปีที่แล้ว
paper trading in live market 23 sep bajfinance
paper trading in live market 22 sep Bajfinance in Tamil
มุมมอง 294 ปีที่แล้ว
paper trading in live market 22 sep Bajfinance in Tamil
NSIC & EDII, வேலை வாய்ப்பு, சுயதொழில் பயிற்சி, தொழில் கல்வி / Job fair, Suyatholil, Thoḻil kalvi
มุมมอง 2305 ปีที่แล้ว
NSIC & EDII, வேலை வாய்ப்பு, சுயதொழில் பயிற்சி, தொழில் கல்வி / Job fair, Suyatholil, Thoḻil kalvi
ஒரு கிலோ கழிவு பிளாஸ்டிக்கிற்கு அரை கிலோ அரிசி Half kg rice free for 1 kg garbage
มุมมอง 255 ปีที่แล้ว
ஒரு கிலோ கழிவு பிளாஸ்டிக்கிற்கு அரை கிலோ அரிசி Half kg rice free for 1 kg garbage
Why are the values of 200ema so different? Is there any other formula for it?
@@aditya37formula is sa.me but we need to add more data for 200 ema.
@ullankaiulagam5045 how to do it
Increase the number of days. It will get the data from Google finance.
Share google excel sheet
@@Kumkum39-r2s follow the steps as per the video you will get your own sheet. First try it. If you face any issues I will help you.
bro ithu auto update aaguma
@@jayspades5947 yes aagum
bro cci ku google sheet la panna mudiuma
@@jayspades5947 yes
How abt for investment?
As per rules lm not supposed to recommend stocks to buy or sell. If our subscribe need the Excel report, I will share it in my video. You check with your financial advisor.
@@ullankaiulagam5045 I don't have any so asked you if ur ok to let me know I can share you my mail id u can guide me
Hi SIR, could you share that Google sheet with us.. Looks nice
@@gulamhussain4727thanks for your feedback. Formula to get data are already shared in description in My previous videos (just copy and paste from discription). See my play list for formula and coding.
not getting proper information from 1.28 to 2.03 minute. Not edited properly
From 1:28 I have shown my template. When the company name is given in the column 1, it. Will automatically pull the data from Google finance to Google sheet. See my past videos from my play list for the formula and how to get the data.
Shar the google sheet in discription so that we can download it will be a great help
@@rosythomas3860 @rosythomas3860 thanks for your feedback. I have shared the whole formula in discription. If you Follow the steps as per the video. You can create your own sheet by copy and paste. Only thing is you have to change the greater than and less than text to symbol.<>. Because you tube channel is not allowed to use this symbol in discription. This is mentioned in the top of the discription itself.
How to download this file sir
Sorry I'm not getting your point. Are you asking about how to download the file from nse website or from Google finance.
Hi Brother, Innaki nan ready pannunen nenka solli irukka maari but Zerodha RSI and this sheet rsi are different
Check the cell and the formula applied because minor error also change the value.
Thank you sir
I didn't understand your language but follow your steps and done the job succufsully Thank you so much. I appreciate your knowledge. You have calculated the RSI with clearly and almost 100 % Results. Hope will find more videos on stock Market indicators and other strategies
how can we do on time fame 15 min for intraday
For 5, 10, 15 30 min data, we need write a script. If you like this video share it to your friends. I'm waiting for 500 subscribers. I will share the coding and procedures soon.
Unable to understand the language but could able to apply the steps shown, thank you for the video. I have got 302 rows of data in first steps. I've edited the cell number accordingly in the formula. There is a difference in RSI calculated to what are on Kites or Trading view platforms. Not sure if I am missing something, If you could share the google sheet, it would be very helpful.
Thanks for your feedback. This video is uploaded 2 years back, Due to very less subscribe I have deleted all the sheets from my system. Once I got 500 subscribers I will recreation the sheets and share it to all.
sir how to put rsi value on my excel sheet please let me know
Sir, Microsoft Excel will not support the Google finance formula. It will be applicable for Google sheets only. If you want in Excel create the data in Google sheet as per the video and save the Google sheet as Excel.
Hindi sir
@@tirthmore9365 sorry friends I don't know Hindi. All the formula are available in the comments section. See the video slowly it definitely helps you.
How to contact you Pls call 9969065838 Pls message before call
Reply
Bhaiya hindi me bolne me kya problem hai
Sister, I didn't know Hindi.
SIR hw to contact u
For what purpose
@@ullankaiulagam5045 i want rsi screener i will pay
Sir please have a revisit to this video ,its not showing correct value and how to track full nifty 100 stocks this way , please give editable google sheet link if possible,many many thanks for ur efforts it had helped a lot.
Hi abhi, good evening, Send your email id I will share the link/sheet on or before Sunday.
hello Sir, How can I get EMA data on hourly time frame in google sheet
There is no default option for 1 hour report. We have to write a script that. I will share it once my channel reached 1 thousand subscribers.
Very useful video
Thanks
Very good
Thanks
Can you help in creating EMA instead of SMA like the one shown in video --> th-cam.com/video/NRqPg0Yf-wc/w-d-xo.html ?
EXELLENT INFORMATION SIR. SO I WANT 100 & 200 EMA IN WEELY BASIS, HOW FORMULA CREAT ? PLEASE PROVIDE ME.
Change the text "daily" to weekly you will get the weekly data. For 100 and 200 ema increases the number of weeks as per the needs.
@@ullankaiulagam5045 change but not get value. Showing incorrect.
Sir, you have done very intelligent work. Will you please give me the said Googlesheet for RSI with formula. Hope to receive from you. I have tried lot, but every time I failed.
I had deleted that sheet. Please check the replies for the previous viewer it will help you to fix the issue.
CAN YOU SENT ME THIS SHEET
Sorry I don't have that sheet now. Try this. Symbol TCS =sort(GOOGLEFINANCE("NSE:"&B1,"all",WORKDAY.INTL(TODAY(),-320),TODAY(),"daily"),1,0) Change (RSI) GAIN (RSI) LOSS (RSI) Average Gain (RSI) Average Loss (RSI) RS RSI 14 =E307-E308 =if(G307>0,G307,0) =if(G307<0,-G307,0) =AVERAGE(H294:H307) =AVERAGE(I294:I307) =J294/K294 =100-(100/(L294+1)) =(13*J294+H293)/14 =(13*K294+I293)/14 =J293/K293 =100-(100/(L293+1)) Symbol ='nse 50 stocks'!A2
FOR MONTHLY
Google formula is available only for daily and weekly. There is no formula for monthly reports.
Bro, Is it possible to make weekly RSI from Daily RSI or do we need to change formula ? Please sollunga
In formula, change the term 'daily' to 'weekly' to get the weekly report.
I had no clue what Yield Farming was a few months ago. I had heard of it and knew people were making thousands of dollars doing it but had no clue on how to participate in it. So I started researching and had a good friend from Binance show me how I could participate in it. I am now making 10% daily returns! Who knows how fast 10% daily returns can grow?!! let's do the maths, let's say you invest $500, 10% of $500 is $50, now do it daily for a period of six months and see how much you will be getting, it is quite amazing, even those holding their coins buying low to sell high will not even be making what we are making within that time frame. But more importantly, you get to compound that daily! CRAZY! Yes, we are moving towards a crypto economy, whether we want to or not. Might as well find out what it is, and MAKE A FORTUNE from it. I know a lot of us thinks if the return is high, in this case, 10% a day, then it won't be around very long, well you are wrong because yield farming has been around for a while and will always be around for a very long time, and simple video proof will show how your investments will MAKE more profits for you on the Yield Farming Platform. You really don't have to do anything, it is all done by automation, the good news is that this particular investment option helps investors who seek to put their cryptos/alts long term instead of losing to the bears, once you set up your account all you do is watch your profits grow within your desired time frame. I have been in the home-based business industry and have been involved in all forms of online investment ventures for over 9 years and have NEVER seen ANYTHING as Profitable as this.I am earning over $600 per day within my first 36 days (do the maths!) and most of the folks I have referred including some of my business associates are at over $200 Per day within 3 weeks (once again do the maths) and the list goes on as I have referred so many folks that are just making profits while they sleep and within 2,3 weeks or 1,2,3,4,5,6 months can collect their profits which are all being Paid INSTANTLY! you can start with as little as $350 or more, You can choose to be totally Passive and earn commissions every few minutes or be active and make even more money quicker. Who wants to participate and get 10% daily from this amazing investment means with crazy profit results?! (joephethan135@gmail.com) so I can provide you with proof and how you can get involved as well
Thank you so much can it be possible to make like a price. can we do for RSI for 500 stocks at a time i.e., automation. here you have shown individual stocks.
Yes possible.
Thank you so much ! This is only one which works for me , I tried several formulas but none of them work , only this works thank you so much
You are welcome.
Great effory sir....how to update ema on nextday....date is not changing.....
# effort....
Thanks for your feedback. Formula will automatically update the daily date and values.
Yeah....thnx once again sir.....
Sir...how to use this sheet for different time frames..... pl advise. Thnx
@@prakashpatel9548 google provides only day time frame. If you need different time frame, you have to create your own time frame by using Google scripts. If I get more request from subscribers I will create the video with different time frames in Google sheets.
Hai Sir, can you share a sample google sheet , its not working I am out side country , i dont know why the nse values are not loading , i do use tabs, any way to contact you , thank you in advance.
share your email id, I will share the google sheet link for reference.
Your mail id please.
Hai, my google finance details are not loading, can you help with it in your formula
apply tab in these places "(tab)". you will get the data's =sort(GOOGLEFINANCE("NSE:"&B2,"close",WORKDAY.INTL(TODAY(),-320),TODAY(),"daily"),1,0) "(tab)"10 "(tab)"20 =AVERAGE(B3:B310) "(tab)"=AVERAGE(B3:B310) =ROUND((2*B308-C309+C$2*C309)/(C$2+1),2) "(tab)"=ROUND((2*B308-D309+D$2*D309)/(D$2+1),2)
Thanks, bit complex, as for every stock, I need to create a sheet, is there a formula which I can enter directly in the first sheet?
=sort(TRANSPOSE(index(GOOGLEFINANCE("NSE:"&A4,"close",WORKDAY.INTL(TODAY(),-180),TODAY(),"daily"),0,2)),0,0). &A4= symbol in cell put this formual you will get the values in horizontaly. then apply the calculation formula in the same way you will get the values in the first sheet.
@@ullankaiulagam5045 Thanks very much, will try it out
@@ullankaiulagam5045 Hi tried using this function but i only get the values but date is not mentioned and it doesnt match with data of vertical
Super Bro, It working. only thing need to edit formula correctly. Thanks a lot :)
will it automatically update the values in google sheets daily ?
yes
@@ullankaiulagam5045 but am able to get yesterday ema values get updated today morning only. Is it possible sir to today current Ema values in Excel ?
Sorry RSI values
@@VijayS-ri9uw as per Google, close value will be available on next day only. You can try with price value for current date for live RSI movement. But variation in value will be there from 3:30 to 9:15am because price is not same as close price.
Formula parse error.
(in cell A1) Symbol (in cell B1) TCS (in cell A2) =sort(GOOGLEFINANCE("NSE:"&B1,"all",WORKDAY.INTL(TODAY(),-320),TODAY(),"daily"),1,0) Try this
Bro formula copy panna mudila
Try this. Symbol TCS =sort(GOOGLEFINANCE("NSE:"&B1,"all",WORKDAY.INTL(TODAY(),-320),TODAY(),"daily"),1,0) Change (RSI) GAIN (RSI) LOSS (RSI) Average Gain (RSI) Average Loss (RSI) RS RSI 14 =E307-E308 =if(G307>0,G307,0) =if(G307<0,-G307,0) =AVERAGE(H294:H307) =AVERAGE(I294:I307) =J294/K294 =100-(100/(L294+1)) =(13*J294+H293)/14 =(13*K294+I293)/14 =J293/K293 =100-(100/(L293+1)) Symbol ='nse 50 stocks'!A2
How to fetch weekly and monthly macd histogram value or 1 hr value Can i fetch value for 1 hr,1 day,1 week and 1 month macd value with histogram as its positive or negative
In step two, I used the formula for daily data (last line "daily"). You can change the daily to as per your requirements. Note. Hourly data will not be available in google sheet. You have to use Google scripts for the hourly data.
Very nice
Thanks