Trading Journal: How to track stock trades in Excel?

Поделиться
HTML-код
  • Опубликовано: 6 янв 2025

Комментарии • 203

  • @aakashbhattad
    @aakashbhattad 10 месяцев назад +3

    How to customise for when we bring additional capital and also the return generated during a period on the capital?

  • @studieon
    @studieon 11 месяцев назад +1

    I want brokerage added one

  • @tusharpatel371
    @tusharpatel371 Год назад +2

    It is a very good excel sheet for trading and the best thing is that Vinay Bhai Solanki is a very nice person.

    • @yogeshjalgaon3222
      @yogeshjalgaon3222 Год назад

      bhai ise use kayse kartey per mujey to abhi tak mail per excel shit mili hi nahi

  • @arungaire7060
    @arungaire7060 4 дня назад

    Hi I tried to make the payment but did not go through. Do you have paypal

  • @Khileshverma06
    @Khileshverma06 7 месяцев назад +2

    please give me access of the sheet for stock general I don't want your accounting software which is very difficult for me as similar to tally, i request please allow by mistake i paid for the software instead of sheet

    • @Excel4Freshers
      @Excel4Freshers  7 месяцев назад

      Ok sir I will share it shortly.

    • @Khileshverma06
      @Khileshverma06 7 месяцев назад

      @@Excel4Freshers have you shared the sheet sir

    • @Excel4Freshers
      @Excel4Freshers  7 месяцев назад

      Yes sir please check your mail

    • @Khileshverma06
      @Khileshverma06 7 месяцев назад

      @@Excel4Freshers OK received thanks

    • @na-z8b
      @na-z8b 4 месяца назад

      @@Excel4Freshers I made the payment I didn't get the excell sheet

  • @arungaire7060
    @arungaire7060 4 дня назад

    It is nice sheet if you could attach the video how to create this sheet would be great

  • @sadiq58938
    @sadiq58938 Месяц назад

    How to get this Excel sheet

  • @kndistributorhouse
    @kndistributorhouse Месяц назад

    I need this Whats is process

  • @galactic25
    @galactic25 5 месяцев назад

    is there a way to import and automatically populate Excel fields from brokerage data such as through API or Python code?

  • @TheEAgroup
    @TheEAgroup 2 месяца назад

    Hi
    I have paid for Trading journal File. Can you please add brokerage and GST coloum in all buy and sell so i get final average price after all expenses.
    Thanks

  • @ayushgupta22122
    @ayushgupta22122 10 месяцев назад +1

    I buy today and it’s work very well ❤

  • @Khaja_Shaik
    @Khaja_Shaik 11 месяцев назад

    Sir, I did not get any download link on my email. usually how long will it take?

    • @Khaja_Shaik
      @Khaja_Shaik 11 месяцев назад

      I received the link but when I booked partial profit in a trade it is showing negative value when some portion is still open. How can I sort out this problem

    • @Excel4Freshers
      @Excel4Freshers  11 месяцев назад

      Please check, it can take 24 hrs. If not, please share your mail id

    • @Khaja_Shaik
      @Khaja_Shaik 11 месяцев назад

      @@Excel4Freshers I received the link and also downloaded. I have entered some holdings at profit which are partially sold and held partial quantity. Now the net pnl only showing a negative number. Plz rectify this

    • @Iam_Aditya_1
      @Iam_Aditya_1 11 месяцев назад

      ​@@Khaja_Shaikbro can u send me sheet

  • @crypto_ai878
    @crypto_ai878 Год назад

    HDFC BANK NOT SHOWING OR GOOGLE PAY OPTION NOT SHOWING ON PAYMENT METHOD

  • @ahmedirfan4950
    @ahmedirfan4950 8 месяцев назад +1

    How to make these sheet

  • @its_little_krishna_ji
    @its_little_krishna_ji 5 месяцев назад

    I download and this sheet add used cap and net cap is not add in totoal cap and this minus used cap - total cap. But in dashboard data is right . Why ❔

    • @Excel4Freshers
      @Excel4Freshers  5 месяцев назад +1

      Hello sir can you please share screenshot on Instagram - excelforfreshers

  • @prabirdalui9969
    @prabirdalui9969 Месяц назад

    Maine buy kiya, mujhe %gain, holding time and %annual gain add karna hai, kaise karu ?Instagram nahi hai mera pls helped me... thanks

  • @joehier7591
    @joehier7591 Год назад

    Does this include FiFo principle?

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Nope, this works with a weighted average method.

  • @Tapas_Biswal
    @Tapas_Biswal Год назад

    hello ismea aur kuch colom add kar sakte like Sl Mind set Target, automatic calculation of stock unit from capital

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Bilkul!! Aap last inn sabko add kar sakte hai.

    • @Tapas_Biswal
      @Tapas_Biswal Год назад

      @@Excel4Freshers but formula kese apply kare and dash board mean kese ayega bo

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Agar dashboard m aap unko bhi chahte ho toh sheet ko edit karna padega. Agar aap excel formulas fluently use karte hai toh sheet ko aap easily edit kar sakte hai.

    • @Tapas_Biswal
      @Tapas_Biswal Год назад

      @@Excel4Freshers ok. Anyway I made the payment pls share the link to download

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Please check your mail you get download the link on your mai.l

  • @mobinahmedquadiri1628
    @mobinahmedquadiri1628 3 месяца назад

    And please send the link of how to buy excel sheet

  • @mobinahmedquadiri1628
    @mobinahmedquadiri1628 3 месяца назад

    Had to buy excel sheet, software has been bought by mistake, please return the amt

  • @omtechnologies8575
    @omtechnologies8575 11 месяцев назад

    your excel sheet not updateing after no. 20.please reply i send you mail. i purchased your excel sheet

    • @Excel4Freshers
      @Excel4Freshers  11 месяцев назад

      Dear sir, please watch the complete video once, drag down all table range.

  • @ravipanchal4517
    @ravipanchal4517 6 месяцев назад

    Sir i got the email for trading journal and verify otp but still not downloading

  • @souvikmallick9646
    @souvikmallick9646 Год назад

    Hi , I downloded the excel. The this is that how we can add more stocks on the graph filter that u have used. Only few stocks name are showing ?

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Yes that shows only 5 stocks, in which you have the highest profit.

    • @Iam_Aditya_1
      @Iam_Aditya_1 11 месяцев назад

      Send me this sheet bro

  • @pssajwansajwan3209
    @pssajwansajwan3209 6 месяцев назад

    i paid for the journal, but unable to access. pls help

  • @hirenthakker2919
    @hirenthakker2919 10 месяцев назад

    How to add broker in percentage

    • @Excel4Freshers
      @Excel4Freshers  10 месяцев назад

      You have to enter the brokerage amount. Brokerage %age is not fixed in any segment.

  • @kamrantanoli3105
    @kamrantanoli3105 Год назад

    Hi, is this sheet only available for India customers. I m trying to buy but asking for India phone no. Plz guide . Thanks

  • @Succeify
    @Succeify Год назад

    Is this available now I want to buy???

  • @phulkhan8855
    @phulkhan8855 4 месяца назад

    how much price of this sheet,
    i want to buy
    how i can buy

  • @young_trader212
    @young_trader212 2 месяца назад

    I have made a payment but didnt receive the sheet

  • @AMITKUMARTIWARI-jk4ue
    @AMITKUMARTIWARI-jk4ue 29 дней назад

    Bhai calculation to batao kaise calculate krte hai

  • @bhavyagoswamiandfamily3209
    @bhavyagoswamiandfamily3209 3 месяца назад

    sheet download kese kare pay kari kar diya

    • @Excel4Freshers
      @Excel4Freshers  3 месяца назад

      Sir sheet apke mail par receive hogi please check your mail

  • @jasbirjuneja2191
    @jasbirjuneja2191 Год назад +1

    SIR VERY NICE AND FRIENDLY BUT WOULD LIKE TO KNOW ABOUT FRESH CAPITAL INTRODUCE HOW WILL IT WORK AND WERE IS TO BE ENTERED

  • @rupeshpatil8796
    @rupeshpatil8796 5 месяцев назад

    Download kaha se kare plZ send link

  • @vinayvarma98
    @vinayvarma98 8 месяцев назад

    Kya yaar payment debit hone ke baad page aa raha hai something went wrong and excel nahi download hua ?

    • @Excel4Freshers
      @Excel4Freshers  8 месяцев назад

      Please check your mail sir, you have received an email

    • @vinayvarma98
      @vinayvarma98 8 месяцев назад

      @@Excel4Freshers Yes got it, thank you.

  • @KUVILalwani
    @KUVILalwani 10 месяцев назад

    Google sheets to hai nhi na

  • @rutviknanda7796
    @rutviknanda7796 11 месяцев назад

    Sir i have paid but didn't get any update or link i also have mailed you and i have share screenshot of payment

  • @adityatanger7201
    @adityatanger7201 Год назад

    bhai mane pay kr diya tha amount pr file kahi mili hi nhi kya chakkr ahai ye

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Please check your mail. File apki mail par bhej de gayi hai.

  • @Motivation_Traders
    @Motivation_Traders 5 месяцев назад

    Dashboard kaise banaye Hain uska video upload kijiye

  • @manizshrestha1559
    @manizshrestha1559 3 месяца назад

    Hi sir i am from Nepal & how can i buy your excel sheets?

    • @Excel4Freshers
      @Excel4Freshers  3 месяца назад

      Please share your mail on Instagram - excelforfreshers
      I will share the file with you.

  • @kunaldhumal0021
    @kunaldhumal0021 Год назад

    Hi Vinay,
    I have paid the amount and haven't received the trading journal. Can you check and revert back.

    • @Excel4Freshers
      @Excel4Freshers  Год назад +2

      Dear sir please check your mail, you will get a download link on your mail.

    • @kunaldhumal0021
      @kunaldhumal0021 Год назад

      @@Excel4Freshers Thank You!.. For the quick responce🙂

  • @goyanijignesh2813
    @goyanijignesh2813 8 месяцев назад

    I paid did not get the file do you send excel file email ?

    • @Excel4Freshers
      @Excel4Freshers  8 месяцев назад +1

      Will check and confirm you shortly.

  • @kedarkuks6963
    @kedarkuks6963 10 месяцев назад

    I paid but did not get the file. Do you send excel file in email?

    • @Excel4Freshers
      @Excel4Freshers  10 месяцев назад

      Yes please check your email

    • @goyanijignesh2813
      @goyanijignesh2813 8 месяцев назад

      I paid did not get the file do you send excel file email ?

  • @rajeshmallick6235
    @rajeshmallick6235 9 месяцев назад

    i have paid but didnt get file

  • @shabazshaikh6353
    @shabazshaikh6353 10 месяцев назад

    I have downloaded , it’s superb thank you.

    • @na-z8b
      @na-z8b 4 месяца назад

      howt you downloaded

  • @satyabansethi8933
    @satyabansethi8933 3 месяца назад

    Sir how to contact you

  • @hritikpatil378
    @hritikpatil378 Год назад +1

    Pehale sale kiya or badame bai kiya to ye sheet kya kam ki

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Bade bhai phale buy hi Kiya hai sahi se dekho or smjho

    • @thetradingmonk7754
      @thetradingmonk7754 Год назад

      ​@@Excel4Freshersbro vo short karne ki baat kar raha hai... means pehle short kiya nd badme cover karne ke liye buy kiya ese

    • @thetradingmonk7754
      @thetradingmonk7754 Год назад

      Hritik bhai short selling karo tab bhi sheet sahi kaam karegi...pehle aapko exit vale colum me short vala trade enter karna hai aur jab book karo tab buy vale colum me entry karni hai simple to hai yar

  • @pateljainish3550
    @pateljainish3550 7 месяцев назад

    Kyaa isme short ki entry daal sakte hai ?

    • @Excel4Freshers
      @Excel4Freshers  7 месяцев назад

      Nahi sir, it is designed to make for long only.

  • @RajeshSharma-rk9sr
    @RajeshSharma-rk9sr 5 месяцев назад

    How to buy Sheet.. and how to download

  • @Hardeepkaur-y7c
    @Hardeepkaur-y7c 4 месяца назад

    I have made my payment already, how to download the sheet????

  • @BongTechBro
    @BongTechBro Месяц назад

    buy ho gaya,,, file kaha mile ga sir

  • @prakashbhagwat7127
    @prakashbhagwat7127 Год назад

    Bro can you create business Excel for me?

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Yes I am interested, if you have an idea and if it's practical to do. 🙂

  • @DipakPatel-pt4es
    @DipakPatel-pt4es 3 месяца назад

    Sir maine payment kar diya hai pr is sheet ko Kai se download karein vo samaj me nahi aa raha hai plz guide karein.

    • @Excel4Freshers
      @Excel4Freshers  3 месяца назад

      Sir file apko mail par receive ho gayi hogi

  • @patidarramesh5298
    @patidarramesh5298 2 месяца назад +3

    ye sari chez to terminal pe dikh hi jati hai usme excel me aane ki kya jarurat hai

    • @rajdeepthakur1442
      @rajdeepthakur1442 18 дней назад

      Lagta hai bhai tum new ho aage ja kr jarurat padegi

  • @ruushbh
    @ruushbh Год назад

    Sir sheet me auto fil nahi ho Raha please solve my query
    The sheet I received is not complete. Please mail the sheet again. Thanks.

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Please share your mail id on Insta.
      Insta id - tallydictionary

    • @ruushbh
      @ruushbh Год назад

      Done
      Please chake

  • @innovativeteachingideas2024
    @innovativeteachingideas2024 Год назад

    why the netP/L is showing minus sign? what does thecolour code of netP/L cell shows?

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      If it shows negative that means you are making a loss in the particular trade.

  • @syedfaizanulhaq5654
    @syedfaizanulhaq5654 4 месяца назад

    Hi friend i need this excel sheet i am not from India can u explain how i get this file ? Please i needed if possible can u Mail me thanks

    • @Excel4Freshers
      @Excel4Freshers  4 месяца назад

      Please share your mail id or dm on Instagram - excelforfreshers

  • @ramyashiva9365
    @ramyashiva9365 6 месяцев назад

    Sir I have paid for excel & still not received it

  • @QuizGamesMarathon
    @QuizGamesMarathon 8 месяцев назад

    bhai mujhe ye buy karna he kese pay karo apko me pakistan se hon

    • @Excel4Freshers
      @Excel4Freshers  8 месяцев назад

      Please mail me at vinnaysolanki@gmail.com

  • @swagatamsarkar405
    @swagatamsarkar405 Год назад

    sir made payment but did not got excel sheet

  • @dsouzakiru
    @dsouzakiru Год назад

    I paid money.. but dint download why?

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Please check your mail, if you have not received any mail. Please mail me @ vinnaysalanki@gmail.com

  • @Succeify
    @Succeify Год назад +1

    Hello is this still available????

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Yes it's available check description

    • @murarisharma3151
      @murarisharma3151 2 месяца назад

      @@Excel4Freshers I have purchased today where it will reflect

  • @akshayraman4498
    @akshayraman4498 8 месяцев назад

    I send 89 rs but you have not update excel sheet answer please

    • @Excel4Freshers
      @Excel4Freshers  8 месяцев назад

      Please check your mail sir.

    • @akshayraman4498
      @akshayraman4498 8 месяцев назад

      Yet you have not told me about my payment that was done in favour of you if do not answer my message then I will think it is a froud for payer if you get and unable to provide me soft ware I have to taken legally action against you responce immediately

    • @Excel4Freshers
      @Excel4Freshers  8 месяцев назад

      Hello sir can you please tell me which software you have paid for and also please share your mail id

  • @innovativeteachingideas2024
    @innovativeteachingideas2024 Год назад +1

    while doing exit entry if we dont write the name of the product how will we knw that what product exit is done lil confused
    ..i paid for the sheet its very nice i am only confused while doing exit entry that do we have to make the same product entry as purchase inthe first row? or entry can from any products from the list ..

  • @imeshrana8215
    @imeshrana8215 2 месяца назад

    Sir dashboard kaise creat karen😅

  • @yadwinder-g6o
    @yadwinder-g6o 5 месяцев назад

    kese download hogi

    • @Excel4Freshers
      @Excel4Freshers  5 месяцев назад

      Hello sir please check your mail and please confirm.

  • @amendrasinghGangwar
    @amendrasinghGangwar 5 месяцев назад

    I paid for the journal, please send me the file. I'm unable to download. Waiting for it since morning. Please yaar bhej do file,

  • @motisk9859
    @motisk9859 5 месяцев назад +1

    It should have been blank. Profit and loss will be shown after sale.That is why the net capital balance is decreasing from capital.

    • @Excel4Freshers
      @Excel4Freshers  5 месяцев назад

      Hope you have checked the updated file.

  • @tonythomas5249
    @tonythomas5249 Год назад

    What if we make more than 3 entries and 2 exits for same stock?

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      You can make multiple entire formulas work the same as I explained in this video and for exit i explain 2 exits

  • @vinayakdhamone7161
    @vinayakdhamone7161 5 месяцев назад

    Product not received

  • @theview_wind7459
    @theview_wind7459 Месяц назад

    same share mai 5 time purchase karunga sir to wo entry 4 entry kaon se section daali jayegi
    aur multiple time same trade mai agar exit kar raha hun 1 se jayaada exist same product ka alage date pe kaonse section me

  • @makarandbendre8543
    @makarandbendre8543 5 месяцев назад

    Can you mail me this sheet

  • @BongTechBro
    @BongTechBro Месяц назад

    OTP DENE KA BAD KOHI FILE DOWNLOAD NEHI HORAHA HEI SIR

    • @Excel4Freshers
      @Excel4Freshers  Месяц назад

      Sir apko file mail par aa gayi hogi please check your mail.

  • @ramuacharya7597
    @ramuacharya7597 Год назад

    टेबल और फार्मुला कैसे डाले ओ भी बनाके दिखाओना सर

  • @shahidmalik6517
    @shahidmalik6517 Год назад

    I have made payment for your sheet .but link. Got expired and sheet was not delivered or downloaded. I have mailed your attaching screenshot of payment. Kindly do send. Me file..

  • @sanjayshaw7466
    @sanjayshaw7466 7 месяцев назад

    Sir maine payment kiya par download nahi huwa

  • @mannatraj6174
    @mannatraj6174 4 месяца назад

    jaha tak aapne type kar ka waha tak calculate ho ja raha hai uska baad se nahi ho raha hai.

  • @anandlunawat1548
    @anandlunawat1548 Год назад

    Very well managed journal bro, to the point. just one doubt Can I customize i.e. want to add more than 2 rows of selling, if yes, can you briefly guide pls. Also have paid, but after payment there was neither a receipt nor have recieved the link. Can you pls check and revert

    • @Excel4Freshers
      @Excel4Freshers  Год назад +1

      You can customise it as you want. You have to change formulas for the dashboard or for the Net Profit section.
      Can you please share your mail id so I will check and forward this sheet.

  • @yogeshnaik6798
    @yogeshnaik6798 3 месяца назад

    Sir mane pay Kr diya tha amount pay kiya tha firbhi file mane kahi nahi mili hai please sir file bhej do please sir mane email pr nahi dekhi hai mail pr payment ka receive invoice thi please sir software bhejdo

  • @sanjeevmonk
    @sanjeevmonk Год назад

    I PAID BUT DIDNT GOT LINK TO DOWNLOAD EXCEL

  • @carmechanicaltech877
    @carmechanicaltech877 8 месяцев назад

    Hi install nahi hota hai

    • @Excel4Freshers
      @Excel4Freshers  8 месяцев назад

      Sir stock journal ke 2 version hai.
      1. Excel file jisme apko install karne ki jarurat nahi hai.
      2. Software, software ko apko install karna padega.

    • @ImranKhan-wp5lp
      @ImranKhan-wp5lp 6 месяцев назад

      ​@@Excel4Freshersbhai kaise milegi

  • @nitinshinde2451
    @nitinshinde2451 2 месяца назад

    sir excel nahi mili

  • @rajdadhaniya2417
    @rajdadhaniya2417 Год назад

    Formula mai error aaraha hai

  • @angel-fairy786
    @angel-fairy786 Месяц назад

    Maine payment kar diya plz download link kaha hai

  • @sameershemi
    @sameershemi Год назад

    Good job bro . This one time payment only right? And I can make multiple sheet for monthly separately?

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      In this file there are 2 sheet, in 1st one you will get dashboard with generate automatic and the 2nd one we have enter sale and purchase data this data we will enter date wise.
      This file we cannot generate automatic monthly sheet, however if you want, you can add sheets and copy and paste month wise data.

    • @sameershemi
      @sameershemi Год назад

      @@Excel4Freshers okay I will purchase thank you..

  • @Nikhisony
    @Nikhisony Год назад

    sir payment to ho gaya par sheet nahi mila na koi mail aaya

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Sir sheet ka link apke mail par aayega please aap apni mail check kare

  • @gurdev264
    @gurdev264 Год назад

    very informational and effective useable. Best wishes from Kapurthala, Punjab. 👋

  • @prolongtrader7874
    @prolongtrader7874 Год назад +5

    better to create this with google sheet which is free not every one can use excel/afford

  • @ttkvlog111
    @ttkvlog111 2 месяца назад

    thank you sir mail par sheet aa gayi hai

  • @SanghmitraNagdawane
    @SanghmitraNagdawane Месяц назад

    Banega paise ya udenga account ky line h sir😂😂😂😂😂😂

  • @vinayakdhamone7161
    @vinayakdhamone7161 5 месяцев назад

    Phir ek bhejiye.sir

  • @krishnabori7372
    @krishnabori7372 Месяц назад

    Payment Kar Dia......... Download Kaise Kare?

  • @Bhupendrasinh2414
    @Bhupendrasinh2414 5 месяцев назад

    Mene payment kiya lekin muje koi treding general ka excel sheet mila nahi payment honeke bad direct muje Instagram me redirect kardiya or kahibhi Treding general ki excel sheet nahi mili

    • @Excel4Freshers
      @Excel4Freshers  5 месяцев назад

      Dir please check your mail

    • @amendrasinghGangwar
      @amendrasinghGangwar 5 месяцев назад

      I also paid but I am not able to download the excel, please help

  • @ashishgl9244
    @ashishgl9244 Год назад

    Good excel sheet, made payment today on 28-05-2023, waiting for excel file.

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Thanks, please check your mail to get this file. 🙂

    • @ashishgl9244
      @ashishgl9244 Год назад

      Waiting for excel bro yet nothing received in mail.

    • @Excel4Freshers
      @Excel4Freshers  Год назад

      Please wait till tomorrow I will mail you tomorrow.

  • @pavanbadshah0
    @pavanbadshah0 11 месяцев назад

    ye sheet mai bana sakta hu ishke liye pay kyu karu😂😂😂

  • @Motivation_Traders
    @Motivation_Traders 5 месяцев назад +1

    Iska bhi charge kar rahe ho 😂

  • @Viraltraveltrader2086
    @Viraltraveltrader2086 3 месяца назад

    bakwas hai download nahi ho raha hai

    • @foodlovers1445
      @foodlovers1445 3 месяца назад

      Mein buy Kia pr koi sheet ki link hi nhi aayi

  • @adameuinv
    @adameuinv Год назад

    😗

  • @vikaschendke7770
    @vikaschendke7770 2 месяца назад

    I have made a payment but didn't recieve the sheet