logo
down
shadow

How to get Taiwan Stock Exchange Index in google spreadsheet


How to get Taiwan Stock Exchange Index in google spreadsheet

By : ravindra
Date : November 21 2020, 04:03 PM
I think the issue was by ths following , How to get Taiwan Stock Exchange Index in google spreadsheet? This index do exist in google finance under https://www.google.com/finance?q=TPE%3ATAIEX
code :
=GoogleFinance("TWII"; "price")


Share : facebook icon twitter icon
How to retrieve stock price from Google Finance with 4 decimal places into google spreadsheet?

How to retrieve stock price from Google Finance with 4 decimal places into google spreadsheet?


By : Arul Ahmad
Date : March 29 2020, 07:55 AM
To fix this issue It appears as though this function has been depreciated in GAS. You might want to look into a way to do it using Yahoo.
R: How do I change gaps (holidays) in a time series of a daily index of the stock exchange by the previous day's informa

R: How do I change gaps (holidays) in a time series of a daily index of the stock exchange by the previous day's informa


By : user3350992
Date : March 29 2020, 07:55 AM
Any of those help I'm usin R language and working with time series daily stock index from differents countries. In order to make comparisons between of differents indexes,(like correletaion, causality etc..) I need that all the series have the same number of lines, but because diferents holidays in diferents countries, the number of lines in each series change. , Package xts is useful here:
code :
DF <- read.table(text = "           Date    Open    High     Low   Close     Volume Adj.Close
1288 2010-01-04 1116.56 1133.87 1116.56 1132.99 3991400000   1132.99
1287 2010-01-05 1132.66 1136.63 1129.66 1136.52 2491020000   1136.52
1286 2010-01-06 1135.71 1139.19 1133.95 1137.14 4972660000   1137.14
1285 2010-01-08 1140.52 1145.39 1136.22 1144.98 4389590000   1144.98", header = TRUE)

DF$Date <- as.Date(DF$Date)

library(xts)
X <- as.xts(DF[,-1], order.by = DF$Date)
na.locf(merge(X, seq(min(DF$Date), max(DF$Date), by = 1)))
#              Open    High     Low   Close     Volume Adj.Close
#2010-01-04 1116.56 1133.87 1116.56 1132.99 3991400000   1132.99
#2010-01-05 1132.66 1136.63 1129.66 1136.52 2491020000   1136.52
#2010-01-06 1135.71 1139.19 1133.95 1137.14 4972660000   1137.14
#2010-01-07 1135.71 1139.19 1133.95 1137.14 4972660000   1137.14
#2010-01-08 1140.52 1145.39 1136.22 1144.98 4389590000   1144.98
dates <- seq(min(DF$Date), max(DF$Date), by = 1)
#you might have to adjust the following to the translations in your locale
dates <- dates[!(weekdays(dates) %in% c("Saturday", "Sunday"))]
na.locf(merge(X, dates))
Getting Tokyo stock price data to appear on Google spreadsheet

Getting Tokyo stock price data to appear on Google spreadsheet


By : user3572553
Date : March 29 2020, 07:55 AM
around this issue I have no problem retrieving price data of US stocks. For example, to retrieve Apple price data, this formula =GOOGLEFINANCE("AAPL","changepct")/100 works fine. When I tried to retrieve Tokyo stocks price data, this formula GOOGLEFINANCE("TYO:1969","changepct")/100 cannot work. Both formulas look similar. I cannot figure out why. Is it because Tokyo stocks are not supported by Google Finance? ,
Is it because Tokyo stocks are not supported by Google Finance?
Stock Inventory - Send email when cell value < 2 (Google Spreadsheet)

Stock Inventory - Send email when cell value < 2 (Google Spreadsheet)


By : farhan khan
Date : March 29 2020, 07:55 AM
I wish did fix the issue. When the "onEdit" trigger fires, it receives the event object as parameter containing some useful information about the context, in which the edit action occurred.
For example,
code :
    function onEdit(e) {

        // range that was edited
        var range = e.range; 

        //value prior to the edit action
        var oldValue = e.oldValue;

        //new value
        var value = e.value;

        //sheet the action came from
        var sheet = range.getSheet(); 

        //cell coordinates (if edited range is a single cell)
        //or the upper left boundary of the edited range

        var row = range.getRow(); 
        var col = range.getColumn();


      }
var productsColIndex = 1; //column A index;
var inventoryColIndex = 2; //column B index

var range = e.range;
var value = e.value;
var sheet = range.getSheet();


var editedRow = range.getRow();
var editedCol = range.getColumn();

var productName = sheet.getRange(editedRow, productsColIndex).getValue();



//checking if 
//1) column B was edited 
//2) the product exists in column A
//3) new value is less than 2

if ((editedCol == inventoryColIndex) && productName && value < 2) {

    //code for sending notification email. 

 }
form where i can get the script for adding bse(bombay stock exchange) realty stock chart

form where i can get the script for adding bse(bombay stock exchange) realty stock chart


By : Azure
Date : March 29 2020, 07:55 AM
Hope this helps I have to add BSE Realty stoock chart into my web site from where i can get this scripts. , We dont sell scripts here.
shadow
Privacy Policy - Terms - Contact Us © festivalmusicasacra.org