HOW TO view historical data of Sensex & Nifty indices with Google Docs Spreadsheet

The GoogleFinance function can be used to fetch historical data for a specified time period.


Try these to get historical data of Sensex & Nifty indices for the first 9 days of September 2013:
=GoogleFinance("BSESN", "close", "09/01/2013" , "09/09/2013", "DAILY")
=GoogleFinance("NSEI", "close", "09/01/2013" , "09/09/2013", "DAILY")


You can even go back in time. The Sensex was at 4031.55 this day in 1997!

Comments

Post a Comment

Popular posts from this blog

Reverse string without using temp

#include <stdio.h> #include <string.h> void reverse(char *, int start, int end); int main(int argc, char **argv) {         if (sizeof(argv) > 1) {                 printf ("Given string :%s\n", *++argv);                 reverse(*argv, 0, strlen(*argv) - 1);                 printf ("String after reverse : %s\n", *argv);         }         return 0; } void reverse(char *str, int start, int end) {         if (start < end) {                 str[start] = str[start] + str[end];                 str[end] = str[start] - str[end];                 str[start] = str[start] - str[end];         } else ret...
Read more

Using Monkey Tool

This first post is dedicated to a wonderfull tool => Monkey ! If you had never heard of this tool, your life is turning better now. Monkey is a simple tool which allow to generate pseudo-random gestures , on a device or on an emulator . Shortly, you can in a few seconds simulate a user using your application, but a pretty stupid one (just as all users ?) because all his actions will be generated randomly. These actions won’t make any sense, but the aim here is to detect bugs in your app, and this can be very useful. Note 1 : This is absolutely not a substitute to other tests you should do (like unit tests…). Do what I say, not what I do  Note 2 : For this tut, I suppose you have one emulator or a device connected in debug mode (with ADB drivers installed). I won’t detail this part. Here we go, launching cmd, and browsing to [android-sdk-path]**/platform-tools. The basic command to use monkey is the following: adb shell monkey <options> For exampl...
Read more

RUN JAVA PROJECT IN ANDROID STUDIO

You can compile and run java module as stand alone java project in Android Studio IDE. Follow the below steps  Open your Android project in Android Studio. If you do not have one, create one. Click  File > New Module . Select  Java Library  and click  Next . Fill in the package name, etc and click  Finish . You should now see a Java module inside your Android project. Add your code to the Java module you’ve just created. Click on the drop down to the left of the run button. Click  Edit Configurations… In the new window, click on the plus sign at the top left of the window and select  Application A new application configuration should appear, enter in the details such as your main class and classpath of your module.
Read more