Hi, Shrewd!        Login  
Shrewd'm.com 
A merry & shrewd investing community
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd
Search
Shrewd'm.com Merry shrewd investors
Search
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd


The week's question
In December 2024, in the thread "Re: BRK: Why Not XOM?", BreckHutHigh asked the members: "What about the long road trips with kids?" This week it is put to everyone again. The button below opens the small thread re-asking it - read what others have said so far, then give your own answer as an ordinary reply.
Answer this questionContinue to Shrewd'mThis note won't appear again
Investment Strategies / Mechanical Investing
Unthreaded | Threaded | Whole Thread (13) |
Author: Aussi   😊 😞
Number: of 6131 
Subject: Re: Retrieving Historical price Data
Date: 03/10/25 7:13 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 7

Elan

When the retrieving site went down a few months ago I contacted Jason at J S <strimp101@gmail.com and he immediately fixed it. I have recently sent a note again but no response yet.

As for Wisesheets

If you don't want to bother in the short term, you can send me a list of stocks and the period when you want pricing, and I can return a csv file.

If you want to set up Wisesheets, here is a link.

wisesheets.io: Wisesheets - The Ultimate Spreadsheet Add-On for Stock Investors

It is $60/year, but I found a $15 coupon fairly quickly. The free version is not sufficient for pricing data.

It is an add on that you have to go through the Microsoft store, if you have 365, or through google if you use googlesheets. Once you have the add on, it is quite easy to use. Put a list of tickers in a column A2 downwards, put the command =WISEPRICE(A2:A387, "AdjClose",350)in cell B1. A 387 is the last cell for my ticker list, use what is the last for you. 350 is the number of calendar days I want retrieved. It only retrieves trading days so there are no blanks to worry about.

There are various prices that can be retrieved. High, low, close and other data.

As mentioned, I think adjusted close is not correct as it is missing an adjustment for the most recent dividend.

I have communicated with the help desk a few times. Not real responsive but I did get answers, or a reply that they would check with their vendor.

Aussi
Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to Aussi here — and replies get answered. Reading is free; so is joining the conversation. Join Shrewd'm »
This community has written 6,115 posts about Mechanical Investing. The article-length ones it recommended most:
Dividend investing · 52 recs · 2025
Non-Mag7 screen · 34 recs · 2025
OT - Div yields and returns · 32 recs · 2024
Using AI to generate backtesting programs · 30 recs · 2025
Rankings for 19Dec2022 · 29 recs · 2022
Unthreaded | Threaded | Whole Thread (13) |


Announcements
Mechanical Investing FAQ
Contact Shrewd'm
Contact the developer of these message boards.

Best Of MI | Best Of | Favourites & Replies | All Boards | Followed Shrewds | Open Questions | Moving a community