Build Your Own Custom Stock Screener With Trading View And Google Sheets

[@BTD1717]

This is awesome- great video!!

[@nexusfission]

Thanks so much!

[@SindhiSaazOfficial]

Can we get data of nadayara Watson smoothers indicator into google sheet like rsi?

[@nexusfission]

Since the code for this algorithm is published and is available in tradingview www.tradingview.com/script/amRCTgFw-Nadaraya-Watson-Smoothers-LuxAlgo/ , you can clone the copy of this doc, modify to add alert with customized json as per your requirement.

[@dbhuwan]

so can i use this method to add 500 stocks to googlesheet and get custom indicator value against each of the 500 stocks? Im asking this because TV allowes only 400 alerts that too in premium subscription

[@nexusfission]

They have ultimate . Which supports upto 1000 alerts, but thats pricy. Rather create two accounts and combine them. There are no other options as i could see as of now

[@2k5grow]

API isnt avaible for sign up anymore.:(

[@uditvish726]

const UserSchema = new mongoose.Schema({
username: { type: String, required: true, unique: true },
password: { type: String, required: true }
});
// User model
const User = mongoose.model('User', UserSchema);
// Register route
app.post('/register', async (req, res) => {
const { username, password } = req.body;
try {
const hashedPassword = await bcrypt.hash(password, 10);
const newUser = new User({ username, password: hashedPassword });
await newUser.save();
res.status(201).json({ message: 'User registered successfully' });
} catch (err) {
res.status(500).json({ error: 'Error registering new user' });
}
});
// Login route
app.post('/login', async (req, res) => {
const { username, password } = req.body;
try {
const user = await User.findOne({ username });
if (!user) {
return res.status(400).json({ error: 'Invalid username or password' });
}
const isMatch = await bcrypt.compare(password, user.password);
if (!isMatch) {
return res.status(400).json({ error: 'Invalid username or password' });
}
const token = jwt.sign({ userId: user._id }, 'secretkey', { expiresIn: '1h' });
res.status(200).json({ token });
} catch (err) {
res.status(500).json({ error: 'Error logging in' });
}
});
// Middleware to authenticate token
const auth = (req, res, next) => {
const token = req.header('Authorization').replace('Bearer ', '');
if (!token) {
return res.status(401).json({ error: 'Access denied' });
}
try {
const verified = jwt.verify(token, 'secretkey');
req.user = verified;
next();
} catch (err) {
res.status(400).json({ error: 'Invalid token' });
}
};
// Protected route
app.get('/protected', auth, (req, res) => {
res.status(200).json({ message: 'This is a protected route' });
});
// Start the server
const PORT = process.env.PORT || 5000;
app.listen(PORT, () => console.log(`Server running on port ${PORT}`));

[@nexusfission]

Which API you are referring to ? There are no APIs here. It mostly redirecting the tradingview alerts as webhook to backend and to the googlesheet. Please let me know more details and i would recommend the right way