How Digital Invitation, E-greeting Can Ease Your Pain

With ever increasing use of smartphones, many traditional things are fading too fast. It is changing the way we interact with our friends and family. It has made it simple to send interactive messages through social media apps using emoticons, smileys, stickers etc. It can be used to send digital greetings and invitation cards as well.  

Send a customised Digital video invitation card 

Physical invitation cards not only involves printing costs, but also need considerable time and efforts to get them delivered to the intended recipient. SMS, e-mails or even directly speaking to the person are the common alternatives to invite for a weekend party or small family function. 

Sending digital invitations is yet another option available on smartphones. It is very simple to create a digital card using MS Paint or create one-page  slide in  powerpoint. Save it as an image and post it at social media profile page or send it to a select group or recipients as using facebook, whatsapp, twitter etc. 

Also see : Print Large Posters and Banners on Standard A4 printer
Video Greetings : Do-it Yourself !!

It is easy to choose from a list of 'Standard' templates as per a specific occasion and make a customisation. Use your creativity and thoughts to put thins in place as per your requirements.
     It is So! simple and easy to do it !!

Free version creates a watermark on the video invitations. However, if you don't want it you need to a little bit more. Once you are done with the video animation, play it to preview and use any screen capture utility to capture the full screen video and export it on local computer. if required do further video editing with 'photos' utility in windows 10.

Safe, Reliable and Inflation-proof returns on your Retirement Corpus . . . | Multi Option Deposits

Retirement corpus planning is a crucial aspect to continue living with an existing lifestyle, during the those days when a regular income in form of salary stops, while monthly expenses continues.  

How to wisely invest the superannuation funds ? 

Don't be in a hurry to have a financial plan and you must take your time to identify the financial goals. Avoid making a mistake of jumping too quickly in a product without a proper understanding of potential risks and expected returns.

Cash-in Hand money is the single most preferred and even a best option for sake of liquidity and convenience. There is no alternate to 'Hard' cash in terms of ease and interchangeability. Carrying cash in bigger amounts has a serious limitation while safe-keeping in secure vaults is another issue that can't be ignored. Also, there is no return on accumulated cash. Therefore, any cash over and above monthly expenses has several drawbacks.

Soon after getting retirement funds in your saving account, there is one thing that you must do as early as it can be. It must be a default choice to park retirement funds or any lump sum amount. It is even suitable for an ultra short term duration. It would surely give you better returns than regular saving account.

You must consider these important points seriously before charting a custom-built financial plan, otherwise it could adversely affect your returns and eventually financial freedom in a longer term. 

• Do not forget to make your Retirement Corpus Inflation proof.
if superannuation funds are parked in a regular saving account for a longer period of time, inflation would eat-up your interest income and would make negative returns on your capital. You must not let it happen at any cost.
• Pay-off any outstanding loan or mortgaged property

Although its too common to tell, yet you must not ignore to payoff any outstanding loan.  If you did not plan for a regular income, any contingency could hamper your liquidity or put you in trouble in those carefree days.


Park at least 3-6 month expenses in an Emergency Corpus


It is must to have a contingency fund either in cash or its equivalent. Careful planning for any health related contingencies is an important aspect. Safety and accessibility without any time delay are the prime factors that must be considered while parking emergency funds .

Risk-free Investment options

Retirement funds can be invested in multiple option based on risk profile and expected rate of returns. Although they are risk-free but considered as safest, reliable and inflation proof options available to investors as given below :

• Online Multi-Option Deposits or Flexi-Deposit Accounts

It is an awesome product that provides safe, reliable and risk-free regular income I It is a unique combination of Saving and Term deposit account that features a seamless liquidity  at par with a saving account as rate of interest, same as applicable to a normal term deposit account. It is suitable for almost any type of investors, irrespective of their risk appetite. These features makes it a default choice for parking funds both for emergency or as a standby avenue, by the time it is deployed as per plan.
Senior citizens get an additional rate of interest over and above applicable rates. Unlike normal deposits, partial withdrawals in multiples of a thousand rupees are allowed. Funds are automatically 'Sweep-out' of linked muti-option account if there is insufficient balance in the saving account as per need, while remaining amount will continue to earn at same rate applicable to initial deposit.
These deposit account are also termed as saving-linked 'Flexi-deposit' account by some banks. It is even more convenient, if you already hold a saving bank account with State bank of India or any other bank with internet banking facility. It just takes a few minutes, using online facility to place a request to create a new MOD account as well as an instant redemption request, at the comfort of your home.

• Fixed Deposits or Tax Saving Term deposits

Fixed Deposit is a safe, reliable and traditional investment avenue suitable for both retirees as well as other investors. Although It has a restricted or limited liquidity due to penalties on premature withdrawals, yet investors can fragment funds across different maturities to manage liquidity as well as associated interest rate risks.

• Senior Citizens’ Saving Scheme (SCSS)
Any depositor can open an account, either individual or joint, for a single amount in multiples of  one thousand  rupees, up to a maximum amount of  fifteen lakhs, along with valid age proof. As the name itself indicates it is an exclusive product for retirees with a higher rate of interest, i.e around 8.6% payable at the end of every calendar quarter. No compounding of interest is allowed. 
SCSS has a maturity of  5 years subject to a further extension of 3 yrs after maturity.  It is available both at banks as well as post offices. Liquidity is highly restricted that is permitted only after one year. Penalties in range of 1 to 1.5 percent, are applicable for premature withdrawal by depositor even after one year.




Pradhan Mantri Vay Vandana Yohana (PMVVY)
It is yet another exclusive product for senior citizens by government of india. It provides an immediate pension for senior citizens 60 years and above .It can be purchased by paying a lump sum amount. The plan provides for pension payments of stated amount for the policy term of 10 years, with return of purchase price at the end of 10 years.
No medical examination is required. Premature exit is allowed during policy term under exceptional circumstances like Critical/Terminal illness of self or spouse . Surrender Value payable in such cases is 98% of the Purchase Price. 
Depositors may opt for a min of 1000 unto a 10000 monthly pension. Maximum purchase price for ant mode of pension is fifteen lakhs rupees.

Liquid Mutual Fund Schemes 
It is a borderline option for a risk-averse investor to have a tax efficient investor who are looking for a long term investment avenue. Liquid funds are an ideal option to park emergency funds. They can also be used for temporary deployment of surplus funds, to tide over prevailing market conditions. They are one-step up in the hierarchy of products based on liquidity.


Pros :
Higher returns as compared to normal saving account.
Instant redemption facility upto fifty thousand rupees per day.
Tax benefits for long term investments.
Better returns in a increasing rate cycle.
Cons :
No tax benefits if investment are held for less than three years.

Also read: Are liquid funds a 'logical' alternative to Saving Bank Deposits !!

Low risk to moderate Investment options

• Debt Mutual Fund Schemes 
Debt Mutual Funds mainly invest in a mix of debt or fixed income securities such as Treasury Bills, Government Securities, Corporate Bonds, Money Market instruments and other debt securities of different time horizons. Generally, debt securities have a fixed maturity date & pay a fixed rate of interest.
There is a wide range of fixed income or Debt Mutual Funds available to suit the needs of different investors, based on their risk profile and Investment horizon.
• Hybrid or Balanced Mutual Fund Schemes 

High risk Investment options

• Equity Mutual Funds  
Invest in the equity mutual funds either as part of SIP or wait until the stock market corrects itself . On an average, equity market corrects significantly once in 2-3 years. That is the time when investment can be made in equity mutual funds for very handsome returns.
• High Dividend Yield Stocks 
Although equity involvements are not suitable for all investors, yet those who are willing to take some risks or have prior knowledge about equity investments and associated risks may choose to consider investment in high dividend yielding stocks of companies, that are fundamentally sound and available attractive valuations mostly during market corrections. 
Here, the sole intent to get tax free dividend income on long term equity investments for capital appreciation as well.

Download Any ebook, Scientific article, Fiction or Standards for Free !!

Download e-books and pdf files using Library Genesis

This search engine provides a e-book downloads in multiple formats. Just type the book title in search bar and it would provides a list of entries related to the book title.

                                                                     Web address :  

                                                                              
                                                                               http://gen.lib.rus.ec  

                                             ( Select and Right click on > Choose "Go to  http://. . . ")

Also Read : Advanced Google search for free stuff and downloads

Are liquid fund schemes a 'logical' alternative to Saving Bank Deposits !!!

Retail investors or individual must have an emergency fund to provide financial security, atleast  equivalent to 3-6 months of expenses. Safety and Liquidity is the prime factor to consider for it. It should be accessible at ease without any unpredictable time delay. It is expected to meet any short term contingencies that may arise due to a sudden Job loss, an accident, long leave or temporary sickness, any sudden business expenditure or whatsoever it may be

Cash-in Hand money is the single most preferred and a best option for the sake of liquidity. Nothing can beat physical cash in term of ease and interchangeability. But there are so much limitation associated  to it including carrying bulk in cash and thereafter keeping it safe.

Saving Bank accounts and Term Deposits are other two natural choices that supersede surplus cash. Still, It doesn't make sense to put all your eggs in same basket. Keeping all your money in fixed deposits or saving accounts is not ready made a tax efficient strategy. 

If your are in a higher tax bracket, Too much exposure to fixed deposits may eventually be increasing your tax burden. It clearly indicates a either bad or a lack of investment planning.

Are there any alternatives to fixed deposits ?? 

           . . .  in terms of liquidity, Tax efficiency and suitable for to a risk-averse investors  !!

Its no so difficult to see people,  who are so much scared of Stock Markets that they have the same perception even for mutual funds as well. They consider both as synonyms. Thanks to inherent volatility in  stock market that they even do not hesitate to put it at par with some sort of 'gambling' or betting. It is very hard to convince people with such mindset, to make them explore schemes that are even suitable for a risk-averse profile.

Surely, stock markets are a bit risky as an asset class and not suitable for everyone. It is meant for  aggressive investors based on their risk-appetite.  Mutual funds are too versatile and offers a broad spectrum of schemes suitable to almost every type of investors. They are not just focused on stock market, but have schemes that has noting to do with stock markets. Such schemes are even suitable even for a better allocation of Retirement Corpus as well.

Mutual funds matrix is mainly focused on Risk profile, Time Horizon, Tax efficiency and Expected Returns, that is very helpful to select a specific category to allocate funds based on risk-appetite. 

What makes them comparable with Saving bank deposits

Liquid funds are an ideal option to park emergency funds. They can also be used for temporary deployment of surplus funds, to tide over prevailing market conditions. They are one-step up in the hierarchy of products based on liquidity.

Liquidity :

'Same day liquidity' is available under liquid schemes by fund houses. Instant redemption facility is offered by some AMCs, wherein you can get the amount in your bank account, within minutes of a redemption request. At present, sebi has allowed it up to ₹ 50,000 only. Reliance mutual fund even provides an ATM card against such a scheme than can be used for cash withdrawal. T+1 day liquidity is common and provided without any restrictions by almost all mutual funds. It makes them a better alternative to saving bank accounts.

Also Read: How to Multiply or Leverage 'Same day' Redemption in Liquid funds

Flexibility :

Lock-in period in fixed deposits is a main barrier of Liquidity. Many a times investors hesitate to break a Fixed deposit, just because of  premature withdrawal penalties or lower than committed rate of interest payable.

Interest rate sensitivity,  fixed deposits are insensitive to interest rate cycle, once committed for a specified duration, you have no choice but to continue with it. However, Liquid fund offers huge advantage in an increasing rate cycle. RBI interest rate hikes reflects in Net assets value whenever debt instruments are replaced after maturity. 

There is no entry or exit load, lock-in applicable on  liquid funds. Hassle-free 'Switch-out' to other equity schemes can be done with just a few clicks,  anytime when the market valuation are good.

Taxability :

It makes no difference to tax liability unless they are held for long term (more than 3 year). Only after 3 years, investors can claim long term capital gains to be taxed at 20% with indexation benefits.

Difference between Liquid and Other Debt fund

Liquid funds invest money in short term debt instruments, mainly below 91 days. Average maturity for these schemes is much less as compared to other Debt fund schemes. That is the reason for their Low Interest Rate Sensitivity, Stable and more predictable return investments.

Also Read: How to Multiply or Leverage 'Same day' Redemption in Liquid funds

Beware !! . . . if making lump sum investment above 2 Lakhs in Mutual funds

Why it is important to read this, before an investment above 2L

Even those investors who are regularly investing in mutual funds since a long time,  may not be aware of some important guidelines that may have an adverse impact on their investments. Unless you are an avid investor who never miss to have a through look on finer prints given in Key Information Memorandum (KIM) every time before choosing a new scheme, you are very likely to face some unexpected shocks related to applicable NAV as some important aspect are not prominently shown on websites or promotional  literature. 

I am sharing an important point that you must keep in mind before doing a purchase/ switch-in transaction for an amount above two lakhs, if ignored may result in considerable dent in return on investment. However, It can easily be taken care of, if done with a proper planning. 

Have you ever noticed a delay in unit allocations for a transaction within cut-off time ??

It is more common a thing, if you make switch-out/in transaction between two schemes of a mutual fund well within cut-off time, applicable for both schemes.  

However, cut-off time is not the only criterion to decide applicable NAV for a transaction. In a worst case scenario, if markets are too volatile, you may end-up in losses if there is a trend reversal on the next business day as applicable NAV date. Less units at higher NAV would end-up in a loss where as you were expecting a cost averaging or profit on a sharp decline of previous day !!

Also Read : Auto-updated Equity Stocks Portfolio in Google Sheets

How did it happen ??

Fund Switch Transaction above 2 Lakhs :

Equity market had a sharp decline for the day, I wanted to capture the sharp decline in benchmark index to average cost in an equity scheme. Therefore, I requested a fund switch from a debt fund scheme to an equity scheme with a lumpsum amount above 2 lakhs. It was a successful transaction well withing cut-off timing. Despite that same day NAV was not applied to calculate unit allocations!!  . . .but why ?? I had completed it withing cutoff time yet . . 

It would have been better if market moved in same direction, but unfortunately, market took U-turn and bounced back and eventually I was in loss with less number of units. 

How it was resolved  ??

I validated the written response provided by the fund house and verified it with their Key Information Memorandum and found it perfectly in compliance with stipulated statutory guidelines. 

So, I had no other option than to regret that had it been known to me earlier, I would have planned it a better way.

Why same day NAV was not applicable for it . .  ??

Cut-off timing is just one important aspect, if subscription amount is equal to or exceeds 2 lakh rupees.  Availability of funds for utilization determines the applicable NAV in that case. 

In a switch transaction, fund realisation is based on applicable NAV for redemption in the source scheme and same will only be available on next businesses day for utilisation in Target scheme. 

Therefore, same day Net Assets Value is not applicable to a switch transaction above 2 lakh even before cut-off timing.

Key Information Memorandum Demystifies everything about it  !!!

It clearly says : 

For subscription of Rs. 2 lakh & above: 

In respect of purchase of units of the scheme, the closing NAV of the day on which the funds are available for utilization shall be applicable, provided the funds are realised up to 3.00 pm on a business day, subject to the transaction being time stamped appropriately.

SEBI Frequently Asked Questions has more details on it!!

How is the applicable NAV determined?

Liquid schemes – Subscription

• Where the application is received up to 2.00 p.m. on a day and funds are available for utilization before 2:00 p.m. without availing any credit facility, the closing NAV of the day immediately preceding the day of receipt of application.

• Where the application is received after 2.00 p.m. on a day and funds are available for utilization on the same day without availing any credit facility, the closing NAV of the day immediately preceding the next business day; 

• Irrespective of the time of receipt of application (before or after 2:00 p.m. on a day), where the funds are not available for utilization before 2:00 p.m. without availing any credit facility, the closing NAV of the day immediately preceding the day on which the funds are available for utilization.

Liquid schemes – Redemption

• Where the application is received up to 3.00 pm – the closing NAV of day immediately preceding the next business day; 

• Where the application is received after 3.00 pm – the closing NAV of the next business day.

Other than Liquid Schemes – Subscription

For amount less than INR 2 lakh

• Where the application is received up to 3:00 p.m., closing NAV of the day on which the application is received.
• Where the application is received after 3:00 p.m., closing NAV of the next business day.

For amount equal to or more than INR 2 lakh

• Where the application is received up to 3:00 p.m. and funds are available for utilization before 3:00 p.m., closing NAV of the day on which the application is received.
• Where the application is received after 3:00 p.m. and funds are available for utilization, closing NAV of the next business day.
• Irrespective of the time of receipt of application (before or after 3:00 p.m.), where the funds are not available for utilization, closing NAV of the day on which the funds are available for utilization.

Other than Liquid Schemes – Redemption

• Where the application is received up to 3.00 pm – closing NAV of the day on which the application is received; 
• Where the application is received after 3.00 pm – closing NAV of the next business day. 

Want to see more SEBI FAQs, Lets have a look    Click Here.

Advanced Google search for free stuff and downloads . . .

Search music, videos, e-books and apks using Google Operators 

It is quiet easy to find any type of files using a advanced of google operators, in an iterative  manner with minor tweaking in syntax using different combination of operators and keywords to get desired. A simple syntax  goes like this :

      -inurl:(htm|html|php) intitle:"index.of"+"filetype"+"topic"

Just substitute <filetype> with a single or multiple file types such as (mp3|wma|mp4|mpeg) or maybe (pdf|doc|txt) etc. and also the <topic> with the main context of your query like book title, song, album name, game, apk  name etc.

Some more examples :

This query searches for music files related to singer [Rahman].  

      -inurl:(htm|html|php) intitle:"index.of"+(wma|mp3) Rahman

Here you can find some helpful pdf files for english grammar.

      -inurl:(htm|html|php) intitle:"index.of"+(pdf) English Grammar

Refer below link, if you aant to read more about operators :

http://www.googleguide.com/advanced_operators_reference.html#allinurl

Download pdf files using Library Genesis

This search engine provides a ebook downloads in multiple formats. Just type the book title in search bar and it would provides a list of entries related to the book title.

Trading Volumes Demystified !!

Significance of Trading Volumes !!

Volume is nothing but total number of trades completed during a specific time interval.  It is a good indicator for 'Level of Liquidity' in a stock. Higher the volume  in  a stock, It is considered to  be an  'Active'  stock. Active stocks do have a better liquidity than low volume stocks. Volume information studied as an independent scalar quantities does not have much significance. But if the movement of volume is tracked along with an other chosen data point such as stock price as a time series data, over a specified period of time at regular intervals, It helps to identify the strength of the prevailing trend and detect any red flags.

General theory is that if Price and volume moves in same direction, Trend continues in same direction or else it indicates a warning for Trend reversal. 

Relationship b/w Volume and Stock Price Movement 

Demand and supply concept prevails in most of the scenario. Price continues to rise  when Buyers exceed the number of sellers and volume is also increasing, It indicates that Bullish Trend is likely to continue. However, Reverse is also valid, stock price keeps on falling if more traders want to sell shares than who are interested to buy. Decreasing price with high volume indicates a Bearish Trend. 

               What is the significance of 'Low volume' at Top and Bottom levels ??

Institutional investors or more common term used is for them is 'Smart money', they behaves much like FIFO method. As they have a professional management and set of guidelines and research backed data to arrive at fair value of stock. They tend to exit at higher levels. Retail investor jumps into the prevailing sentiments and buys in relatively smaller lots that results in low volumes at higher levels. Trend reversal eventually takes place when no more buyers at willing to buy it at higher prices.

Also Read : Auto-updated Equity Stocks Portfolio in Google Sheets

In Downward trend,  It is just the same story but other way around, Heavy selling is triggered by the institutional players that sometimes takes a huge momentum leadin to 'Panic selling'.

In general terms, 'Low Volume' itself is an warning or indicator for volatility ahead, due to lack of interest in the market to follow trend anymore. There is high probability for a Trend Reversal at this stage, if the price is trading near crucial Support/Resistance levels. 

However, if a stock abruptly breaks the support or resistance with high volume, Trend is likely to continue in same direction.

Lets put it, simple 
Increasing/Decreasing volume movement has 4 Trading Scenarios with Up/Down price movement. 
Price                               Volume                               Significance                               
Increasing                       Increasing                             Bullish  Trend

Increasing                       Decreasing                           Warning - Possible Trend Revera

Decreasing                     Increasing                             Bearish Trend

Decreasing                     Decreasing                           Warning - Possible Trend Revera

Daily Stock Screener for Decreasing Price with Decreasing volume : See it Here.

House, Plot or Property 'facing' Direction using Online compass

How to get a 'facing' direction for a House Property

Although I am not a vaastu expert or an architect by profession, but It is very clear that direction plays a very prominent role while choosing a rental house, or buying a new house, plot or business property.  Lets answer a too basic or even silly question :  
               Which direction are we talking about . .??
The direction of the house or the ‘facing’ of the house, is the direction you face, while coming out of the house or property. 


The best entry or 'facing' direction is North-East, followed by North-West, East, North and West.  
However, It can just be used as a thumb rule to shortlist a specific site. Keep in mind, there are many other parameters as well that influence overall vaastu compliance of a site or property. It is not easy or a Do-it yourself task to a decision for properties that are irregular in shape, having tilled directions, tapered boundary walls, rounded corners and facing other directions. It is  advised to consult a vastu expert to have a comprehensive site assessment that would take care of each and every aspect related to a house or plot property.  Since I've gone too far in a foreign territory, Lets get back to a more specific context about [ How to identify a 'facing' direction of a property ]. 

Also Read : Auto-updated Equity Stocks Portfolio in Google Sheets

How to get an accurate Direction of 'facing' of Property 

Setcompass.com  is a Google Maps tool for the plotting and recording of compass bearings, distances and magnetic declination or variation for single or multiple Google Map routes.

It can be used to measure a 'facing' direction for any house, plot or building using google Maps. Please see the video for a step-by-step instructions :



Also Read : Use Xpath query to fetch data from a Webpage 

Auto-refresh ImportXML at predefined intervals using Time-Driven Triggers on Google Script

How to create 'Time-driven Triggers' in Google Script 

Functions that pull data from outside the spreadsheet recalculate at the following times:

      ● ImportRange: 30 minutes

      ● ImportHtml, ImportFeed, ImportData, ImportXml: 1 hour

      ● GoogleFinance: may be delayed up to 20 minutes

See more details here.

Time-driven triggers is a very helpful tool for getting periodic updates of [import] functions used in google spreadsheets. There are two ways to do it. First script uses a random number added to the target page as an URL query string.  It by passes the one hour limit by  calling a dummy URL every time at auto-recalculation of google spreadsheet. Since target values are populated directly through scripted formulas, it is tedious to manipulate a large number of function through with it.

 Lets see, how can we set-up a Time-driven triggers in script editor for import functions at a time interval as low as 'on every minute'.  It would be best to use it for upto 5-10 import function, but if you handle more , than go ahead as there is no restriction as such except script may take a little longer to update.

Make sure all you have is a list of URLs and Xpath_query  that you want to get output to values in output Cells after each auto-update.  if you need any help on [Xpath query]  generation see related article or video blog at :

Related : Use Xpath query to fetch data from a Webpage


Just copy and paste the simple code in google script editor :

function getData() {
  var queryString = Math.random();

  var Xpath_1 = "[Your Xpath_query here]";
  var importXpath_1 = '=IMPORTXML("' + '[Your URL link here]' + '?' + queryString + '","'+ Xpath_1 + '")';
  
  SpreadsheetApp.getActiveSheet().getRange('[outputCell]').setValue(importXpath_1);
}

Replace desired values at <[Your Xpath_query here]>, <[Your URL link here]> and <[outputCell]>  in the above mentioned code. save project and allow permissions to 'Run' the script in your gmail account.

Related : Auto-updated Equity Stocks Portfolio in Google Sheets

Utility script for periodic refresh of IMPORT formulas

Above said basic script works well, if you want to populate just a few  import functions. It not easy to manipulate a long list of import functions inside a spreadsheet. I explored the web for this excellent solution that works great. Thank you all contributors to share such a wonderful script. 


Here is the script, :

function RefreshImports() {
  var lock = LockService.getScriptLock();
  if (!lock.tryLock(5000)) return;             // Wait up to 5s for previous refresh to end.

  var id = "[YOUR SPREADSHEET ID]";
  var ss = SpreadsheetApp.openById(id);
  var sheet = ss.getSheetByName("[SHEET NAME]");
  var dataRange = sheet.getDataRange();
  var formulas = dataRange.getFormulas();
  var content = "";
  var now = new Date();
  var time = now.getTime();
  var re = /.*[^a-z0-9]import(?:xml|data|feed|html|range)\(.*/gi;
  var re2 = /((\?|&)(update=[0-9]*))/gi;
  var re3 = /(",)/gi;

  for (var row=0; row<formulas.length; row++) {
    for (var col=0; col<formulas[0].length; col++) {
      content = formulas[row][col];
      if (content != "") {
        var match = content.search(re);
        if (match !== -1 ) {
          // import function is used in this cell
          var updatedContent = content.toString().replace(re2,"$2update=" + time);
          if (updatedContent == content) {
            // No querystring exists yet in url
            updatedContent = content.toString().replace(re3,"?update=" + time + "$1");
          }
          // Update url in formula with querystring param
          sheet.getRange(row+1, col+1).setFormula(updatedContent);
        }
      }
    }
  }

  // Done refresh; release the lock.
  lock.releaseLock();

  // Show last updated time on sheet somewhere
  sheet.getRange(7,2).setValue("Rates were last updated at " + now.toLocaleTimeString())
}

Resources :

1. Periodically refresh importxml() spreadsheet function