Тёмный
No video :(

Moving Average Crossover Signal in Google Sheets with One Advance Formula using Google Finance data! 

Silent Trader
Подписаться 24 тыс.
Просмотров 86 тыс.
50% 1

How to create your won google sheets with moving average crossover
Must Watch Playlist: -
Option: - • Option Strategy
Price Action: - • Price Action
Trading view indicator: - • Trading view Indicator
Automated Excel: - • Trading view Indicator
Social Media Links: -
Telegram - t.me/SilentTrader24
Twitter - / jay_b2427
RU-vid - / @silenttrader24
HIT THE SUBSCRIBE BUTTON AND CLICK THE BELL icon to get Latest Update!
#Niftyprediction #Bankniftyprediction #SgTrader #marketview #intradaystocks

Опубликовано:

 

18 фев 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 106   
@Financetosafe
@Financetosafe Год назад
Very nice making and guidance thanks 👍
@major8forextrading30
@major8forextrading30 10 месяцев назад
Amazing work. I have a question about making one for Forex Trading and if you can fetch and parse data like bank interest rates, GDP, inflation number and Import & Export data for the major 8 currencies around the globe. Perhaps possible to fetch the data from Yahoo Finance page. I would like to hear from you in this regard. Thank you.
@ninja78
@ninja78 7 месяцев назад
for me , the 20 DMA is giving incorrect value e.g. 2.28 for TCS, 18.47 for infy but returns correct value for techm....very strange behaviour...can you pls help ?
@sdmagickids8906
@sdmagickids8906 Год назад
Very nice information is ver help full sir
@gstaccount3243
@gstaccount3243 2 года назад
🌹🌹🌹It's use full knowledge sir... thank you sir 🌹🙏🙏🙏🌹
@SilentTrader24
@SilentTrader24 2 года назад
Most welcome
@azarsayyad8976
@azarsayyad8976 10 месяцев назад
Sir I made my Excel and Excel working fine and giving perfect signal on moving average crossover. Thank you
@purnimabharambe3265
@purnimabharambe3265 9 месяцев назад
I am getting error on my first link. Can u help
@azarsayyad8976
@azarsayyad8976 8 месяцев назад
@@purnimabharambe3265 just follow video.u will make ur own sheet.
@Mambattu8
@Mambattu8 2 месяца назад
Nice video and useful one. Kindly tell what's the syntax for previous day high, previous day low and previous day close with workday function. Thx to help me in this regard.
@guillermobarragan7426
@guillermobarragan7426 Год назад
Very good video!!! Do you have a link to download the form?
@RohithShashishekar
@RohithShashishekar 10 месяцев назад
Can I get the link for Google sheets?
@gstaccount3243
@gstaccount3243 2 года назад
Thank u sir 🙏🙏🙏🙏
@nikhilghonge7506
@nikhilghonge7506 2 года назад
Thank you
@rawpamper
@rawpamper Год назад
Good work Bro
@hiralshah7200
@hiralshah7200 Месяц назад
Hi - You have explained well but I am stuck at the first step as my googlesheet is showing an error when I use the import data function. Can you help?
@vasugiramu4087
@vasugiramu4087 Год назад
can i get the excel sheet
@manojmendhe3093
@manojmendhe3093 Год назад
🙏🙏🙏Great sir g thanks so much sir g 💓💗💟
@atultanna
@atultanna 2 года назад
Weekly TF how do we the data
@mick_mickyplays7860
@mick_mickyplays7860 4 месяца назад
I watched your video today but google sheet isn't able to fetch data from nse it is showing error what to do will really appreciate if you reply thank you for this gem of a video
@turtlelife085
@turtlelife085 3 месяца назад
In this video you count moving average is the SMA or EMA ??? Please guide.
@SaurabhYadavlucknowwaale
@SaurabhYadavlucknowwaale 2 месяца назад
the formula tries pulling data from NSE but returns with error.
@Absoni269
@Absoni269 2 месяца назад
Not able to copy CSV link address from NSE website please guide.
@devang19732002
@devang19732002 2 года назад
cAN WE HAVE FORMULA OR HOW TO CREATE FOR ema EXPONENTIAL MOVING AVG
@AnasKhalid-h4u
@AnasKhalid-h4u Месяц назад
While copy csv link it coming java script why?
@RameshBhadra
@RameshBhadra Год назад
You have created all the excel. If possible then pl share the same to us.
@azharuddinmolla8338
@azharuddinmolla8338 2 года назад
Hello sir, maine avi aap ka video dekha, just awesome, just ek question tha moving average ka formula pe col2 kaha se de. Pls reply
@SilentTrader24
@SilentTrader24 2 года назад
Azhar bhai , woh ek pura formula hi hai...select col2 mean ...avg price me col 2 ka price lega... toh aap jese bataya bas vese likh do aa jayega
@soninikul
@soninikul 7 месяцев назад
importdata function not working
@newsnexus922
@newsnexus922 3 месяца назад
sir i want all time high in excel sheet, could you tell me command for this
@AUTOCADWALABISU
@AUTOCADWALABISU Месяц назад
Sir Data validation korke query me symbol nehi ho raha he... Plz help me
@philosopher703
@philosopher703 6 месяцев назад
Nhi ho rha kuch udate kiya nse ne ?
@kartikbaikar8562
@kartikbaikar8562 Год назад
Sir, i try this formula =AVERAGE(QUERY(GOOGLEFINANCE(symbol ,"close",TODAY()-20,TODAY()),"Select col2")) but not working giving error (Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: col2) . Please help
@SATYA888
@SATYA888 Год назад
It's Col2 not col2
@nightthoughtquotes687
@nightthoughtquotes687 8 месяцев назад
​@@SATYA888thanks bhai😊😊
@MalkanMunshi-tk5bh
@MalkanMunshi-tk5bh 6 месяцев назад
Mai yahi fass gaya hu koi help kar sakta kya
@srinivasrao3349
@srinivasrao3349 11 месяцев назад
Does it give delayed Data or current Data ?? ( I mean Aletrs )
@SilentTrader24
@SilentTrader24 11 месяцев назад
Alert immediately as long as data update . Data depend on the website update
@komaljiwanapurkar6000
@komaljiwanapurkar6000 6 дней назад
sir nse data import nahi ho raha hai kya karu
@TasteMyRecipe
@TasteMyRecipe Год назад
Hi sir... the data imported is taking alot of time to get updated... it is showing a msg down of the sheets ...can we fix it
@SilentTrader24
@SilentTrader24 Год назад
Use excel , that's the best way and fetch data from nse
@TasteMyRecipe
@TasteMyRecipe Год назад
@@SilentTrader24will the excel sheet update fastly...I thought google sheet would work better
@SilentTrader24
@SilentTrader24 Год назад
I use excel .which work faster
@arnavsujal3818
@arnavsujal3818 Месяц назад
सर मेरे google sheet मे एक प्रॉब्लेम हो रही की जब मै nifty 50 लिखता हूं और डाउन साइड खिंचता हु तो निफ़्टी 51 ,52 ऐसे आ रहा है तो क्या करे
@nehabhatia7925
@nehabhatia7925 Год назад
Sir the formula is not working
@geeglu
@geeglu 2 года назад
Importdata worked 1st time but then later it said Could not fetch URL? is there a specific reason why?
@SilentTrader24
@SilentTrader24 2 года назад
you mean URL for stocks name ?
@geeglu
@geeglu 2 года назад
@@SilentTrader24 yes ..it looks okay today...guess it is to do with weekend access to servers
@SilentTrader24
@SilentTrader24 2 года назад
You can add manually stocks name if you do not wish to use URL
@yuvarajsonale6447
@yuvarajsonale6447 Год назад
=QUERY(Indices!B2:H, "Select H where B like '"&C15&"'")
@sujoydey3839
@sujoydey3839 10 месяцев назад
Is it possible to get previous month low high n close of any stock in google sheet
@SilentTrader24
@SilentTrader24 10 месяцев назад
Monthly can .. need to check for previous month
@sujoydey3839
@sujoydey3839 10 месяцев назад
Please let me know hiw to do. Any formula?
@SilentTrader24
@SilentTrader24 10 месяцев назад
support.google.com/docs/answer/3093281?hl=en
@jitenkumarmehta2832
@jitenkumarmehta2832 Год назад
Sir mere me to googlefinance function kam hi nahi karta. Kya muje google sheet download karni padengi
@SilentTrader24
@SilentTrader24 Год назад
Nai ....as long as you have Internet...you can use it
@venkatreddy-vr29
@venkatreddy-vr29 2 месяца назад
Sir Can you do it again of this video
@A.Ram007
@A.Ram007 11 месяцев назад
Share sample format anyone have
@sirpaulrana3834
@sirpaulrana3834 Год назад
I USED THE SAME FORMULA BUT GETTING THE MESSAGE, QUERRY COMPLETED WITH EMPTY DATA
@alokpatel3727
@alokpatel3727 Месяц назад
Previous month ka 20sma kaise nikale.
@puneetsingh2569
@puneetsingh2569 5 месяцев назад
Sir i am not able to import data from NSE into google spreadsheeet
@SilentTrader24
@SilentTrader24 5 месяцев назад
t.me/DonloadExcelfile I have uploaded excel copy ... you may try that
@westnash
@westnash 9 месяцев назад
What is the point in baiting people with English titles and then having a totally non English Narrative?
@marmikbhavsarANANDian
@marmikbhavsarANANDian 2 года назад
20 day MA formula is correct?(Today()-20)), because it will also count non working day and you end counting less than 20 days
@SilentTrader24
@SilentTrader24 2 года назад
You are right , that's drawbacks of Google sheet formula
@caanuragsaraogi
@caanuragsaraogi 2 года назад
@@SilentTrader24 how to rectify that?
@pateloffset5570
@pateloffset5570 Год назад
col2 ki jagah pe Col2 kardo C capital
@kunalpatil1027
@kunalpatil1027 2 года назад
I have some query can u help me
@SilentTrader24
@SilentTrader24 2 года назад
ask , will try my best to help you
@avishekbanerjee7486
@avishekbanerjee7486 5 месяцев назад
my import data formula is not working...................... can anyone give me a suggestion
@SaurabhYadavlucknowwaale
@SaurabhYadavlucknowwaale 2 месяца назад
mine not working too.. shows error while downloading
@kunalpatil1027
@kunalpatil1027 2 года назад
Hi
@SachinJadhav-bn1jk
@SachinJadhav-bn1jk Год назад
sir, i try this formula =AVERAGE(QUERY(GOOGLEFINANCE(A8,"close",TODAY()-20,TODAY()),"Select col2")) but not working giving error (Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: col2) please advise. And sir i have another query. How to import stocks real-time data in sheet. eg. 20221001 09:15:00 10 12 14 16 17 20221002 09:20:00 15 14 12 16 14 20221003 09:25:00 13 12 13 14 19 . . . like this 2min, 5min..... interval please give formula if possible. Thanks,
@yuvarajsonale6447
@yuvarajsonale6447 Год назад
=QUERY(Indices!B2:H, "Select H where B like '"&C15&"'")
@AjaySharma-jv6qn
@AjaySharma-jv6qn Год назад
=AVERAGE(QUERY(GOOGLEFINANCE(A2,"close",TODAY()-20,TODAY()),"Select Col2")) Use Col rather than col it will work for you
@AkashYadav-sg1lg
@AkashYadav-sg1lg Год назад
@@AjaySharma-jv6qn It worked, Thanks Bro
@Nicky3286
@Nicky3286 5 месяцев назад
SHOWING ERROR WHILE DOWNLOADING
@gstaccount3243
@gstaccount3243 2 года назад
Pls release the 2 part vedio of this pls...sir 🙏
@SilentTrader24
@SilentTrader24 2 года назад
Done
@Ranjith_747
@Ranjith_747 2 года назад
@@SilentTrader24 can you please share the link
@premiump4679
@premiump4679 2 года назад
@@SilentTrader24 Please share the link
@azar382
@azar382 8 месяцев назад
Sir how to add 1 hour time fream for crossover?
@SilentTrader24
@SilentTrader24 8 месяцев назад
This data is from Google and they do not provide hourly....Will check and update if there is any formula
@azar382
@azar382 8 месяцев назад
@@SilentTrader24 thank you for your valuable reply.
@Biharikiswari_05
@Biharikiswari_05 4 месяца назад
Sir last wala hua he nhi
@sumandas.5956
@sumandas.5956 Год назад
EXELLENT INFORMATION SIR. SO I WANT 100 EMA IN WEELY BASIS, HOW FORMULA CREAT ? PLEASE PROVIDE ME.
@SilentTrader24
@SilentTrader24 Год назад
=GOOGLEFINANCE("NSE:SBIN", "close",DATE(2019,1,1),TODAY(),"WEEKLY")
@SilentTrader24
@SilentTrader24 Год назад
you can try with this
@sumandas.5956
@sumandas.5956 Год назад
@@SilentTrader24 sir not working. Please help.
@SilentTrader24
@SilentTrader24 Год назад
Brother then sorry ... I have not tried it yet for weekly data
@sumandas.5956
@sumandas.5956 Год назад
@@SilentTrader24 sir please help
@manishsachdevaofficial
@manishsachdevaofficial 4 месяца назад
Bhai ye sheet discription me hi daal do
@singhsusil1185
@singhsusil1185 5 месяцев назад
sir aapka video bahut achcha hai lekin aapka formula dikhai nahin deta please help me
@dangerdagar9427
@dangerdagar9427 8 месяцев назад
File share karo dir
@billanderson6897
@billanderson6897 7 месяцев назад
Very difficult to understand your language. Please put in your title "NOT IN ENGLISH".
@othnielpeter2033
@othnielpeter2033 5 месяцев назад
Complicated
@YogeshContractExpert
@YogeshContractExpert Год назад
Such a good topic has been explained in worst way. Try to be very systemic in chronological order.
@DPatel-rn4xb
@DPatel-rn4xb Год назад
HOW TO GET "VWAP" DATA FOR ANY SHARE
@SilentTrader24
@SilentTrader24 Год назад
Vwap only bhavcopy give .... foe that use Web query in excel
@santoshjdixit
@santoshjdixit 6 месяцев назад
how to get index data like ltp h,l,o,c ? like this video
@singhsusil1185
@singhsusil1185 5 месяцев назад
Very good video!!! Do you have a link to download the form?
Далее
EASILY Make an Automated Data Entry Form in Excel
14:52
Build Your Own Stock Portfolio Tracker On Google Sheets
1:06:25
Build a Stock Watchlist with Live Data in Google Sheets
27:50
Get Stock RSI Value into Google Sheet
12:43
Просмотров 17 тыс.