GOOGLEFINANCE in Google Sheets to track my portfolio

I wanted to keep a track of my portfolio using google sheet.

e.g: if i buy a share let’s say on 07th April 2021 and i know my trigger price, Target 1 , target 2 & SL. i want google sheet to mark each of them with specific color as soon as CMP matches one and another of trigger price, T1, T2 & SL until i sell them.

Share CMP BUY T1 T2 SL Buy Date Sell Date
HDFC 2450 2400 2550 2600 2390 07/04/2021

How to acheive it, i tried comparing CMP columns with other columns but as the prices keeps changing i am unable to track it.

tracking – Can you track an event in Google Analytics when the phone call is made, as opposed to just when the user clicks on the number?

If I understood correctly, and “flow 3” is still on the site, you can track it by throwing a gtag event when a user presses yes to the “do you want to call 0850 XXX XXX” prompt, and then, set the goal on google analytics to record a conversion once the event is sent. If there are problems with throwing ga events, I highly recommend using GTM (Google Tag Manager), which should make implementing this behavior pretty straight forward. Again, all of this is assuming that “flow 3” is still on site.

Good luck!

Use Analytics + Tag Manager to track link clicks of specific URLs

For a PDF brochure that is accessed through a banner link, how would one track the clicks on that banner using Google Analytics and Google Tag Manager?

I’ve been following this tutorial, and this one.

Because a PDF isn’t a page that people land on, nor is it outbound, I need to do this a little differently than in the tutorials (which focus on tracking outbound link clicks).

I’m a noob with Tag Manager, so please include details, and don’t hesitate to explain the obvious. Thanks.

Track your affiliate sales and expenses automatically!

Knowing your figures is the basis of success!

Nifty Stats is a desktop utility, which automatically in regular intervals downloads the stats from your affiliate programs, affiliates networks, advertising networks. Nifty Stats brings automated statistics right to your desktop for any time frame pre-defined by you – and it shows these stats in real time and on regular basis. It is 100% safe and entire communication runs just between your computer and the server of your affiliate program.
Track tens of thousands of affiliate programs, advertising networks and online campaigns!

All your online advertising campaigns tracked in a single window!

Designed for maximum comfort while browsing your programs’ affiliate statistics 24 hours a day, 365 days a year, for example if you are going anywhere without your PC Nifty Stats will send alerts to your e-mail about your sales and rebills, also it can send you a daily summary report of your sales. Wherever you go, your statistics go with you; the Nifty Stats Desktop and the mobile app for Android make sure you receive updates on any new situation or changes to your statistics
Sales forecasts for the upcoming period!

Who wouldn’t want to know how much they will earn the next month? Every good trader needs as much information as possible and it is very important to be able to estimate your future income. Nifty Stats will analyze your current real data downloaded from your affiliate programs and provide a forecast of your possible future earnings.

Get Started for Free
Do you know how much an affiliate program owes you?

Nifty Stats is unique because it shows you how much affiliate programs owe you and lets you keep a history of how much money you have already received. In this way you have a 100% overview of all your earnings due from an affiliate program or advertising network!
Custom code

We can code individual modules into Nifty Stats according to your requirements.

Nifty Stats is modular and we can quickly satisfy any extra needs you might have. We have been developing custom solutions for companies for over a decade, using Nifty Stats plugins to meet their needs. Do not hesitate to contact us if you have any special requirements or are interested in custom plugins.

Get Started for Free

Nifty Stats is 100% Safe & Secure

Your stats are safe because they are only stored locally on your hard drive and you are the only person who can access them.

We do things our way and we have not joined the companies which offer similar products on cloud platforms or self-hosted platforms. We care about our users and so we go for quality instead of quantity. Safe statistics and safe data is our priority.


A Free Virtual Private Server (VPS) for you


We give a free VPS to every Nifty Stats user.
We know exactly what you need and that is why you receive a completely free Virtual Private Server with pre-installed Nifty Stats. It’s available whenever you need it. What’s more, you are not limited to using this VPS for Nifty Stats but you can use it for your daily work!

Join our community of more than 20,000 users and make your work more efficient.
You are one step from analyzing your affiliate and advertising statistics quickly and efficiently. If you decide to continue using Nifty Stats after one month, just buy a license and continue monitoring your statistics. No re-install is needed.

Get Started for Free
30-day fully functional version. Get a fully functional Nifty Stats right now. No credit card required.


ffmpeg – Strip specific audio track from multiple files with batch script

I am trying to create a batch script that will strip a specific audio track from multiple video files using “ffmpeg”.

The audio track has the same ID on all files.
after performing “ffmpeg -i file.mkv I get:
enter image description here

What I want to do is strip the DTS-HD MA audio track. So I created a batch script:

if not exist muxed md muxed
for %%g in (*.mkv) do (
    ffmpeg -i %%g -map 0:1 -c copy muxed%%g

But unfortunately what it does is it strips video track and second audio track (DDP 5.1)

I have tried other ID combos also:

  • 0:0 – Strips both audio tracks
  • 0:1 – Strips video track and second audio track (DDP 5.1)
  • 0:2 – Strips video track and first audio track (DTS-HD MA)

I simply want it to strip the DTS-HD MA track. the closest I came was with 0:2 but that also removed the video track.

What am I doing wrong?

mathematics – track 2D offset after rotation

red is my origin point, blue is my offset, both are 2D vectors, how can calculate blue after rotation?

this is the code I’ve been trying(just throwing things against a wall to see what sticks)

public static Vector2F CalcPointWithRotation(Vector2F origin, Vector2F point, float rotation)
    return new Vector2F((float)Math.Cos(rotation) * origin.x, (float)Math.Sin(rotation) * origin.y);

enter image description here

logging – Do external harddrives keep track of the computers they’re plugged in to?

I know that it’s possible for a computer to set up logging or auditing, and keep track of what devices are plugged into IT. But do external harddrives keep track of what computers THEY are ever plugged in to? Intentionally, or unintentionally? (Assume they have just been taken out of the box from Best Buy — specops IT hasn’t loaded anything on.)

I’m trying to analyze a Samsung T5 right now but I want to know in general.

If the answer is Yes, or Maybe, should wiping the hard drive get rid of this information, or is it stored DEEP in the drive, somehow? I’m always suspicious of how much “wiping” does, even with a multi-pass algorithm.

How to see Word Track Changes in Google Docs/without Microsoft Word?

I don’t have a local install of Microsoft Word, but I’m getting writing feedback in the form of .docx files with track changes on. Ideally, I would like to see the tracked changes in Google Docs, but I haven’t been able to find a way to do that. I would prefer not to have to dive into the XML, but I’ll do it if necessary.

Using Google Analytics to track popularity a series of checkboxes on a webpage

I have a WebPage page that has lots of checkboxes on. Each one does something different. I would like to know which of these checkboxes is most popular with users.

I am aware that I can assign Analytics Events by class to these checkboxes but that would either require me to:

  • Give every checkbox the same class and assign a blanket event
  • Create a new event for every checkbox, using a different class each time

If i were to go with the former and give every checkbox the same class, is there a way in the Analytics dashboard to disaggregate those events by the checkbox ID, or some other variable that differentiates them from each-other?

Equally, is there a better, alternative, way of approaching this?

unity – Why can’t I play 2 animation track at the same time in Timeline for additional Camera?

I try to move and rotate camera at the same time in timeline. To do this, I added two animation track to camera. One animation track changes position of the camera. And the other one changes rotation of camera. But they are not working at the same time. When I press “preview” button, only rotation of camera changes

enter image description here

This video may help understanding if question is not clear